There are many useful command-line applications that are either associated with, or are distributed with, SQL Server. They all have their uses and several become important as part of script-based automation of tasks. It is definitely worth knowing what is lurking in your tools\binn directory.
2014-03-13
7,504 reads
SQL Saturday is coming to Madison on March 29, 2014. This is a free training event for SQL Server professionals and those wanting to learn about SQL Server. Steve Jones and many others will be presenting, so make sure you register early to secure your place.
2014-03-13
1,816 reads
The Change Data Capture feature of SQL Server captures DML changes happening on a tracked table. Arshad Ali demonstrates how this feature can be leveraged.
2014-03-12
2,429 reads
Survey - The DBA-Team wants to hear about your worst day as a DBA. Did a database restore fail due to corruption? Did you accidentally connect to Prod instead of Dev and truncate a table? Anonymity available. The best story will win a $50 Amazon voucher.
2014-03-12
4,076 reads
With the right tools, it is possible to rapidly deploy upgraded databases. By deploying early in development, it's easier to iron out any potential problems that the new deployment could cause in production long before it's time to actually release the software.
2014-03-11
4,431 reads
If you manage a server where you are not in complete control of the creation of databases, or you’re unfamiliar with what settings to change, you may miss things out or set them incorrectly. This metric could pick up on issues that affect performance in obscure ways, and saves you having to search for them when a system suddenly stops performing as you would expect.
2014-03-11
1,279 reads
This free event is coming to Boston on March 29, 2014. Grant Fritchey and many others will be speaking, so make sure you register soon while spots are available.
2014-03-11
1,565 reads
This is the story of how a free addin for SSMS, SQL Code Guard, was created and joined the Red Gate SSMS Ecosystem project.
2014-03-10
5,251 reads
A new series on how you can automate partition management and administration. Hugh Scott explains how this technique helps him manage large deletes.
2014-03-07 (first published: 2010-12-14)
20,128 reads
We have a SQL Failover Cluster Instance in our primary data center, and want to implement a second two node Failover Cluster Instance in our secondary data center. A new two node cluster located in our secondary data center was setup, but I could not create a new High Availability Group between the two failover cluster instances. What went wrong?
2014-03-07
3,721 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
Comments posted to this topic are about the item BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers