SQL Server – Add Date/Time to output file of BCP / SQLCMD
You can export data from SQL Server using BCP command for SQLCMD utility. However, these utilities does not support dynamic...
2013-04-17 (first published: 2013-04-09)
3,602 reads
SQL Server – Generate Calendar using TSQL
Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....
2013-04-09
1,152 reads
T-SQL Tuesday 41 – Presenting and Loving it!
Before we dive in to the post, I’d like to give a big thank you to Bob Pusateri (Blog|Twitter) for...
2013-04-09
792 reads
T-SQL Tuesday #41: How I Got My Start in Presenting
For this month's T-SQL Tuesday, Bob challenges us to discuss how we came to love presenting. Here's my story.
I developed a...
2013-04-19 (first published: 2013-04-09)
1,966 reads
T-SQL Tuesday #41 – Presenting and Loving It
Some Tuesday mornings I have bacon with eggs and an English muffin. Not today though. I am blogging about Why...
2013-04-09
467 reads
Unknown Unknowns: SSAS Version Number and Default Admins
With Service Packs and Cumulative Updates rapidly released for SQL, it can be hard to keep up with what version you have installed where. It’s easy enough to find...
2013-04-09
16 reads
How do I use a variable in an IN clause?
I see this question in one form or another a lot. I’ve seen this or something like it probably half...
2013-04-08
791 reads
Disabling Resource Governor
I had known that the Resource Governor is always running in modern versions of SQL Server. It’s core to the...
2013-04-08
1,119 reads
Presentation Materials “Discovering the Plan Cache” #SQLSat206
This past weekend, I took a quick trek into the land of beer and cheese for the second annual Madison...
2013-04-08
603 reads
PASS Business Analytics Conference
The PASS Business Analytics Conference is almost here! Check out the sessions to be presented at the conference and you will see...
2013-04-08
929 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers