2019-05-03 (first published: 2015-05-05)
2,237 reads
SQL Server
Extract default & Named Instance from @@servername
Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.
2019-05-03 (first published: 2015-04-15)
1,134 reads
Shredding Unicode Japanese characters using SSIS
This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS
2015-03-31
1,288 reads
Check if SQL Server is running
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,749 reads
2015-03-20
1,721 reads
Removing SQL Server Management Data Warehouse (Data Collector)
Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.
2014-09-29
4,806 reads
Another Way to Look at Trees
An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.
2014-09-15
7,574 reads
2014-06-27
2,263 reads
Wandering Towards The Lonely Cloud?
Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?
2014-06-05
98 reads
Leveraging Constraint Evaluation Sequence in SQL Server
Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.
2014-01-27
2,916 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Tracing a performance issue
Hello, We have a SQL agent job that runs daily. It runs a procedure,...
Automating SQL Server 2019 Setup and Configuration Across Multiple Servers
Hi everyone, I’m looking to automate the installation and configuration of SQL Server 2019...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; See possible answers