Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,744 reads
SQL Guatemala
Check instant file initialization and lock pages in memory options
Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...
2018-06-28
2,639 reads
What it is Page Life Expectancy (PLE)
Which cup will you prefer to go the less
number of times to the coffee maker?image was taken from hereLet us...
2018-06-21
226 reads
Collation considerations to create robust queries
Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...
2018-06-11
197 reads
Add a custom report to SSMS
Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...
2018-05-25
616 reads
Query to determine last statistics update for a database
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
114 reads
Quick charts in SQL Server Operations Studio
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
119 reads
Quick tip: Refresh IntelliSense cache in SSMS
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
279 reads
Security: Create and view Audit Logs
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
5,411 reads
Quick tip: format source code in html
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
99 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers