Useful T-SQL queries and scripts to work in SQL Server
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...
2018-12-05
436 reads
Blog Posts
Useful T-SQL queries and scripts to work in SQL Server
This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...
2018-12-05
60 reads
What were you thinking (hidden relationship)???
What were you thinking?
Have you ever been working on some code from another person, and you end up scratching your...
2018-12-05 (first published: 2018-11-20)
2,248 reads
Azure SQL Database – Firewall Rules
If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding...
2018-12-04
240 reads
Azure SQL Database Managed Instance Business Critical Tier Now Available
The business critical tier for Azure SQL Database Managed Instance is now available. Customers needing a higher level of high...
2018-12-04
43 reads
High CPU and Query Store, A Story of Spinlock Heartache
This is going to be a quick look at an issue that we recently encountered, I’m not going to go...
2018-12-04 (first published: 2018-11-20)
2,364 reads
SQL Date functions in SQL Server
SQL date format functions like the DateDiff SQL function and DateAdd SQL Function are oft used by DBAs but many...
2018-12-04
662 reads
SQL in the City is Next Week
Next Wednesday, Dec 12, I’ll be back in the UK with Kathi, Kendra, and Grant for SQL in the City...
2018-12-04
802 reads
System Variables in Azure Data Factory: Your Everyday Toolbox
(2018-Nov-20) After working and testing the functionality of variables within Azure Data Factory pipelines, I realized that it's worth to explore...
2018-12-04 (first published: 2018-11-20)
2,859 reads
T-SQL Tuesday 109: Influence Somebody Invite
How have you impacted somebody in the community?
It has now been 28 months since the last time I hosted a...
2018-12-04
226 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
Alamat Kantor BCA KCU DAAN MOGOT Telp:08218154398
Tlp/Wa_Cs:0821-8154-398 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers