Copying Individual Tables with dbatools
@SQLMonkeyNYC asked on Twitter this morning:
#sqlhelp Does anyone have a product that will back up a single table and restore it to another database? Thanks in advance!!
— The SQL...
2018-11-14
24 reads
Blog Posts
Dates and Times in SQL Server: DATEADD()
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure...
2018-11-14
245 reads
Filtered Indexes in SQL Server
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-11-14 (first published: 2018-11-05)
2,614 reads
Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)
Last week, I was lucky enough to present on the topic of TSQL User Defined Functions (UDFs) in SQL Server at the PASS Summit. My session was live-streamed, and...
2018-11-14
108 reads
SQL Homework – November 2018 – Constraints
You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed...
2018-11-14 (first published: 2018-11-05)
1,939 reads
Switching blog website
For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with...
2018-11-14
198 reads
Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important. Sometimes, we...
2018-11-13
7 reads
Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when...
2018-11-13
1,002 reads
Bert & Pinal Troubleshoot a Slow Performing SQL Server
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL...
2018-11-13
347 reads
Bert & Pinal Troubleshoot a Slow Performing SQL Server
Watch this week's video on YouTube
What happens when you run into performance tuning expert Pinal Dave? Talk about how to troubleshoot a slow performing SQL Server of course!
This week...
2018-11-13
5 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers