How I like to learn a t-sql command
Recently I received a security request and realized I wasn’t comfortable in my ability to script out the t-sql commands...
2013-01-07
843 reads
Blog Posts
How to move file through FTP by CMD ?
CMD code to upload file direct into root of FTP site of server
@ echo off
REM ******** this batch file is to...
2013-01-07
1,666 reads
I Need Your Vote!
Do your civic duty, and vote today!
Voting is now open for SQLBits, to be held in Nottingham, UK this...
2013-01-07 (first published: 2013-01-03)
1,586 reads
January 2013 – Monthly SQL Server Checklist
Today is the first Monday of 2013. Do you know if your servers are ready to take on the first...
2013-01-07
683 reads
Last Weeks Top 10 “Reading” Links #14
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-07
909 reads
SQL Server – Login Failed, cannot open user default database
Each login in SQL Server has a default database associated with it. When you login to SQL Server context is...
2013-01-07
1,809 reads
SQL Server has encountered % occurence(s) of cachestore flush for the % cachestore (part of plan cache) due to some database maintenance or reconfigure operations
Have you seen this type of an informational message in your SQL errorlog before? If so, then I hope the...
2013-01-07
1,151 reads
SQLBits Public Sessions
If you’re over in the UK, or close to it, you’ve probably heard of SQL Bits even if you haven’t...
2013-01-07 (first published: 2013-01-03)
1,535 reads
SSDT – TSQL Unit testing in multiple environments
Late in December, one the long awaited portions of functionality inside SSDT was released to an eager public, that being...
2013-01-07
1,755 reads
SSRS Subscriptions Report
As a part of my series leading up to Christmas 2012, I shared a script to Report on SSRS Subscriptions....
2013-01-07
1,865 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers