Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
Open DBDiff for SQL Server 2008
The DBDiff utility compares two databases and generates a script to synchronize the two databases. In this article, MAK illustrates the various uses of the Open Diff utility.
Database Space Capacity Planning
Describes a process to create a consolidated space forecasting report, which focuses on a "days remaining" metric.
Working at Microsoft
Would you want to work at Microsoft? Do you think Steve Jones does? Read a few thoughts from him on his experience with the software giant.
MSDE – Database Size Limit
Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...
SQL Server Tempdb Usage and Bottlenecks tracked with Extended Events
How do I effectively find out if the Tempdb database is suffering from an allocation bottleneck? Should I create multiple TempDB files per core on this server to improve performance? How do I check this information programmatically?
Using new location-aware data types in SQL Server 2008
With SQL Server 2008, you will have new built-in support for location based data types and supporting geospatial features. Next you will learn how these new data types work.
Weak Passwords Discovered in the 10,000 Disclosed Hotmail/Live.com/MSN leaked accounts
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns
Working at Microsoft
Would you want to work at Microsoft? Do you think Steve Jones does? Read a few thoughts from him on his experience with the software giant.
Working at Microsoft
Would you want to work at Microsoft? Do you think Steve Jones does? Read a few thoughts from him on his experience with the software giant.
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