If you're going to be at Data Moshpit in two weeks, you might be able to pick up one of these limited edition t-shirts.

OMG DATA MOSHPIT IS ONLY TWO WEEKS AWAY!!

#TSQL #ACDC #DataMoshpit #PowerBI #MicrosoftFabric

This is just a brief post containing a script to get table sizes in SQL Server, along with some other information like table type, number of records, partition count, compression type, number of nonclustered indexes and their total size.

https://vladdba.com/2023/08/24/script-to-get-table-sizes-in-sql-server/

#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #tsql

SQL Agent Insight is agentless, nothing is installed on your #sqlserver, ever, nor is there any client-side installation required either.
#TSQL and #SMO are the only methods of gathering the data that you require, and the SMO libraries are included, meaning no other installations are necessary.

Manage your SQL Server Agent estate with SQL Agent Insight. Download for free and use without feature restrictions.

https://brentec.ca

#DBA #monitoring

Translating a query from #msaccess ( :blobcatmeltcry: ) to #tsql in order to troubleshoot something. The Access query uses InStr() https://support.microsoft.com/en-us/office/instr-function-85d3392c-3b1c-4232-bb18-77cd0cb8a55b in which the parameters are in exactly the opposite order than the equivalent CHARINDEX() https://learn.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-ver16

I'm sure this is an organic evolution of disparate, yet similar technologies, but damn it took me too long to figure out why my record counts were so off.

Another week, another video on #tsql by @GuyInACube. This time on the new WINDOW clause, that makes usage of windowing function super easy and clean. Patrick does - as usual - a great job explaining it. Take a look a the video right away! https://youtu.be/KrsNwegpqlk

RT @AzureSQL
COMING 🔜 Transact-SQL Programming Databases with T-SQL for Beginners series

Join @Marisa_Mathews_ & @BuckWoodyMSFT as they create a database together for a real-world application from start to finish using #SQLServer!

#AzureSQL #TSQL #BeginnersSeries

The GuyInACube continue to dive into #tsql, this time Patrick explores the use of the OVER and RANK functions in combination with common table expressions (CTE) in #AzureSQL Database and #AzureSynapse Analytics. Check it out! https://youtu.be/ZKvpiOnwAK4

And another funny comment I left somewhere, names have been altered to protect the guilty...

#programming #sql #tsql #ianap

http://sqlreitse.com/2023/01/20/distinct-or-group-by/

A fun test to see the differences between distinct and group by. I'd love to hear your experiences! #sqlserver #tsql #distinct #groupby #zekerweten

From my blog archives...

Some individuals like to keep jobs in their SQL Server Agent for future code reference; these jobs have no schedule and will never run. For those I say, put them into your favorite code repository, not only for you but for others on your team too.

Below I provide T-SQL that will help identify those agent jobs that have never run so they can be purged or migrated to your code repo of choice.

https://brentec.ca/blog/2022/07/t-sql-script-showing-sql-server-agent-jobs-that-have-never-run/

#sqlserver #dba #monitoring #tsql

Job Posting

Employer: Change Healthcare
Stack: #dotNET, #React, #csharp, #tsql
Location: Remote
Pay: Unknown (Best guess: $109,800 - $183,000)
Description: Change Healthcare is a leading healthcare technology company with a mission to inspire a better healthcare system.
Link: https://careers.changehealthcare.com/job/san-francisco/full-stack-software-engineer/32443/40592191312

Added some t-sql examples for random dates and ISO 8601 format.

https://github.com/mcarr10/TSQLExamples

#tsql

I made #ChatGPT write (questionable) T-SQL so you won't have to.
#sqldba #sqlserver #mssqlserver #AI #tsql
https://vladdba.com/2022/12/20/using-chatgpt-to-write-t-sql

I made #ChatGPT write (questionable) T-SQL so you won't have to.
#sqldba #sqlserver #mssqlserver #AI #tsql
https://vladdba.com/2022/12/20/using-chatgpt-to-write-t-sql

I made #ChatGPT to write T-SQL so you won't have to.
#sqlserver #mssqlserver #dba #sqlserverdba #AI #tsql

https://vladdba.com/2022/12/20/using-chatgpt-to-write-t-sql

From my blog archives...

I like to keep my SQL instances as free from clutter as possible.
I provide a script below that will return all database mail accounts not currently being used by any database mail profile on the current instance.

https://brentec.ca/blog/2022/08/script-to-identify-unused-sql-server-database-mail-accounts/

#sqlserver #dba #monitoring #tsql

#sqlfamily What's your methodology when it comes to mocking up data for #tSQLt?

Say you have a user management system. Do you create a standard set of user data that you then call from all tests setup procedure? Or to you tailor the dataset to the specific test? I like the idea of reusing datasets but worry about the overhead. But then again I also worry about not catching all possible error modes because we didn't account for this new type of user in every test.

#sqlserver #tsql

I just completed "Tuning Trouble" - Day 6 - Advent of Code 2022 https://adventofcode.com/2022/day/6 #AdventOfCode. Interesting challenge today.🧐Loved doing it with #azuresql and #tsql. Will try to write a blog post later. It's all about distinct count and grouping 😎

Hey I have an idea. Let's take the entire collective industry knowledge of #MSSQL #TSQL syntax and flush it down the toilet to save a few bucks. @joshthetechie it was only a matter of time until Mastodon heard how much I hate SAP HANA.

#SAPHANA #GarbageSoftware

I just completed "Supply Stacks" - Day 5 - Advent of Code 2022 #AdventOfCode https://adventofcode.com/2022/day/5, again using only #tsql #azuresql #sqlserver