Notes From SQLSaturday Orlando 2016
This year we held our 10th SQLSaturday, a very nice milestone to hit. I’ll reflect in a separate post on...
2016-11-28
729 reads
Easy to read CHECKDB
If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC...
2016-12-05 (first published: 2016-11-28)
2,487 reads
How to backup local SQL database and restore to Azure SQL database
Hi friends, recently I was finding a way on taking backup of local database and restore that database to Azure...
2016-11-28
979 reads
A Better Way to Execute SSIS Packages with T-SQL
There are several ways to execute SSIS packages that have been deployed to the SSIS catalog, and my favorite way...
2016-12-02 (first published: 2016-11-28)
3,948 reads
Monday Coffee 2016-11-28
MCSA SQL Server 2016
The new SQL 2016 MCSA exams are out and joy of joys, the DBA path no longer...
2016-11-28
435 reads
How to Change an Analysis Services Instance to Tabular Mode
One of my client accidentally set up an SQL Server Analysis Services in multi-dimensional mode instead of Tabular mode. In this...
2016-11-28
1,457 reads
Bree's first blog post... Amazing training deals
Gethyn will be getting me to update this every week, there are some awesome training deals available for £750 + VAT....
2016-11-28
382 reads
A DBA’s Developer Experience and After-Thoughts
After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a...
2016-12-01 (first published: 2016-11-28)
1,894 reads
Columnstore Indexes – part 92 (“Lobs”)
Continuation from the previous 91 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of the...
2016-11-27
608 reads
Why Do People Think Dynamic Data Masking is a Good Idea? - SQL SERVER 2016 #5
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
914 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers