Upgrade or Wait
Lots of debate and disagreement on my recommendation to wait for SQL
Server 2008 instead of upgrading to SQL Server 2005...
2007-07-11
1,434 reads
Blog Posts
SQL Server 2008
Just when I was about to start a pool for the release date, Microsoft announced today it will release on...
2007-07-10
1,384 reads
The Business of Publishing
Despite my casual approach to the editorials and my job, this is still
something of a business and Red Gate wants...
2007-07-10
626 reads
CTEs and where have I been?
I haven't posted much lately, but it has been a busy few months with many family activities. At work, I...
2007-07-09
432 reads
DDL Triggers and CREATE_LOGIN/ALTER_LOGIN
I've been doing a lot with DDL triggers in the last week or so and pulling out the relevant information...
2007-07-09
1,073 reads
The Perils of NewID for Randomizing Results
NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...
2007-07-09
873 reads
Wiki For Books Online
Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...
2007-07-09
584 reads
Service Packs and Support
More coming next week in editorials and already a note on the site, but support for both SQL Server 2000...
2007-07-07
631 reads
Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
703 reads
Latest Service Packs and Books Online
I was reading a new post at SQL Server Magazine titled The More Things Change(full version available to registered users...
2007-07-06
619 reads
Blogs
Extended Events in Azure Data Studio
I know I can use extended events (xevents) in Azure SQL DB when in...
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
SQL Prompt Tips–Using $surroundtext$ in a Snippet
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Forums
Creating Aggregates
Comments posted to this topic are about the item Creating Aggregates
Getting Started with DDL statements of Cassandra Query Language
Comments posted to this topic are about the item Getting Started with DDL statements...
The Balanced Technical Manager
Comments posted to this topic are about the item The Balanced Technical Manager
Ask SSC