SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL Server provides a few methods for you to find...
2011-04-05
28 reads
Blog Posts
SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL...
2011-04-05
803 reads
SQL Validation Functions - 4 Cool UDF's to have handy
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-05
40,745 reads
This appears to be a system procedure..but it isn’t!
G’day,
Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database...
2011-04-05
2,040 reads
To TOP or not to TOP an EXISTS
Earlier this year I had a look at a query pattern that I often see on forums and in production...
2011-04-05
5,784 reads
T-SQL UPPER(): Change an all lowercase string to uppercase
The T-SQL UPPER() command allows you to change a lowercase string to an uppercase string.
For example, it will allow you to change the word...
2011-04-05
1,712 reads
Updated Overlapping Statistics Scripts
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,697 reads
#Meme Monday
Use extended events; they work – and make you appear magical.
– “Write a SQL blog post in 11 words or less”...
2011-04-04
623 reads
A SQL Server Hardware Nugget A Day – Day 4
Day 4 of this series is about the upcoming AMD “Bulldozer” family of processors that is due to be released...
2011-04-04
380 reads
A SQL Story in Eleven Words or Less
Tom LaRock (blog | twitter) proposed a Meme Monday and his first choice of topics was to write a SQL Server...
2011-04-04
700 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU BLOK A CIPETE Tlpn/Wa:6285188120691
Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec. Cilandak, Kota Jakarta Selatan,...
BCA KCP Banjarbaru Telpon/WA:08218168291
BCA KCP Banjarbaru Telpon/WA:08218168291.Jl. A. Yani No.KM 33 5, Guntung Payung, Kec. Landasan Ulin,...
BCA KCP Santa Tlpn/Wa:6285188120691
Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus Ibukota...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers