Insert multiple values sets into a table in one command
The INSERT command has two distinct ways to load data into a table.
INSERT INTO Table (field1, field2) VALUES ('string1','string2')And
INSERT INTO...
2013-02-28
3,446 reads
A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)
Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series...
2013-02-28
2,051 reads
Dust Off That Resume
Since I started regularly attending SQL Saturday events some five years ago, I’ve sat in on a number of professional...
2013-03-08 (first published: 2013-02-28)
3,152 reads
SQL BLOG: Using Triggers for creating history tables in SQL Server
Case Study:1) We need to track the employee table in terms of new records inserted along with the datetime stamp
2) ...
2013-02-28
9,324 reads
"An item with the same key has already been added."
In SQL Server Reporting Services, when adding a new dataset to a report, you may see an error that looks...
2013-02-28
8,582 reads
Check out IT Central Station
If you get some time, head on out to IT Central Station.com. You can provide some valuable feedback on the...
2013-02-28
1,194 reads
Data Warehouse Architecture Presentation Slides
Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter. There were over 200 attendees! The recording of...
2013-02-28
1,629 reads
Optimizing Protected Indexes (was Indexing Encrypted Data)
Why bother encrypting?
Riddle me this batman? Why bother to Encrypt?
As a SQL Server DBA I am primarily responsible for making...
2013-02-27
1,815 reads
We’re Live on the PowerScripting Podcast! (Thursday night, 02-28)
Your MidnightDBAs
Unusually, Sean and I will be guests on someone else’s podcast this week! Tune in live to our PowerScripting...
2013-02-27
1,273 reads
Attaching an MDF with no Log (AdventureWorks)
Attaching an MDF file without an LDF file can be a little tricky. I had to go through this recently...
2013-02-27
2,000 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
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...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers