Pro SQL Server 2012 Practices: Chapter 17
I jumped at the opportunity to write a chapter for this book, Pro SQL Server 2012 Practices, because of all...
2013-03-04
1,702 reads
Notes from SQLSaturday #192
This past weekend I was back in Tampa for the sixth annual SQLSaturday. It’s a trip I always look forward...
2013-03-04
659 reads
Trust in Access
One of the minor features/quirks/annoyances of MS Access is that if you create a single macro or code module you...
2013-03-04
684 reads
What is mssqlsystemresource?
If you are lucky you’ve never seen an error along the lines of:
The SELECT permission was denied on the object...
2013-03-04
1,012 reads
Using Object Typed Variables in SSIS
Note: This will be the first post in a short series on using Object typed variables in SQL Server Integration...
2013-03-04
1,672 reads
Making sure your Triggers fire when they should
As some of you may be aware, triggers are not my favourite thing in the world but like most things,...
2013-03-04
1,088 reads
SQL Server – How to Rename Table/Column in SQL Server
To rename an object in SQL Server you can use sp_rename system stored procedure or you can do this via...
2013-03-04
2,032 reads
Virtualising your SQL Server?
Having just completed the latest revision of Learning Tree's SQL Server Virtualisation and consolidation course I thought I'd share with...
2013-03-04
677 reads
Introduction to the SQL BCP Utility
SQL Server BCP is a command line utility that bulk copies data between instances of SQL Server and data files. ...
2013-03-04
23,548 reads
SQL Server 2012 Diagnostic Information Queries (March 2013)
Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-03-04
1,074 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers