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.
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
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers