2012-10-30 (first published: 2012-10-12)
2,337 reads
Scripts
Lists tables, Stored Procedures and other Objects
This stored procedure helps you list all tables, stored procedures, functions, view and triggers in a database.
2012-10-29 (first published: 2012-10-03)
1,897 reads
2012-10-26 (first published: 2012-10-02)
967 reads
2012-10-25 (first published: 2012-10-12)
1,958 reads
2012-10-23 (first published: 2012-09-12)
2,988 reads
New feature in SQL Server 2012 - Sequence
A new feature in SQL Server 2012 is Sequence. A Sequence object provides functionality similar to Identity.
2012-10-22 (first published: 2012-09-11)
2,070 reads
Show Job Run Snapshot
Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.
2012-10-19 (first published: 2012-09-17)
1,153 reads
Read large C2 Audit Mode trace files
Here's a set of scripts that allow you to save pertinent information from SQL Server Profiler trace files.
2012-10-18 (first published: 2012-09-20)
631 reads
Port check for SQL Server connectivity
Generates a script to check connectivity between a list of SQL Server instances on a specified port.
2012-10-17 (first published: 2012-08-09)
2,136 reads
2012-10-16 (first published: 2012-09-21)
2,567 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
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...
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