Powershell one liner to export data directly from SQL Server to Excel
Most of the times I use the CSV files whenever I need to import or export SQL Server data. And then if I need to do further analysis on...
2019-07-11
4,213 reads
What about orphaned windows users?
I should start off by mentioning that this post is applicable to sql server versions 2012 and up. If you have an older version of sql server, the solution...
2019-07-09 (first published: 2019-06-26)
1,845 reads
Powershell script to find SQL Server instances on remote servers
This is actually part 2 of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there will be a series of...
2019-06-28
7,579 reads
Find clustered index on non primary key columns
First, some blah... blah... blah...
By default when a primary key constrained is created on a table/view, SQL Server automatically creates a unique clustered in order to enforce it. And...
2019-06-27
74 reads
Query machine name of the sql server instance - the hard or the harder way
I was at a client where they are using non-Microsoft clustering technology to achieve the high availability of SQL Server instances....
2019-06-26 (first published: 2019-06-13)
1,744 reads
Powershell script to find new servers in an AD domain
This is actually part of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there...
2019-06-19 (first published: 2019-06-06)
1,363 reads
Do you have rarely used indexes that are hurting performance of writes?
We know that indexes are necessary for query performance but comes with overhead during DML operations. Usually, the overhead is worth the performance gain we get out of them....
2019-06-10 (first published: 2019-05-21)
864 reads
Using Extended Events To Capture Backup and Restore Progress
If you are running a DATABASE BACKUP or RESTORE command manually, SQL Server will show you the progress at a specified % completion interval. For the BACKUP, the default is...
2019-06-03 (first published: 2019-05-16)
981 reads
Find identical duplicate indexes
The purpose of this query is to find identical duplicate non-clustered indexes i.e. indexes on same table with same columns in same order. If you have a need to...
2019-05-30 (first published: 2019-05-15)
880 reads
Find identical duplicate indexes - Revised
I realized yesterday I posted this quickly after testing only against SQL 2016 version. So I decided to also test against SQL 2014 and 2012 versions to make sure...
2019-05-16
66 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kontak BCA KCP Comal Tlp,Cs:0821-8154-393
WA:08218154393 Grand Comal Residence, Jl. Raya Ahmad Yani No.20 Blok EA A19, Dusun II,...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers