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
737 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,495 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
985 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,952 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
437 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,464 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
386 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,909 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
609 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
931 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat BCA KCP Mangga Dua Mal Telp:0821°7555°651
Telp/Wa 628217555651 Mal No. RM, Jl. Mangga Dua Raya No.49, RT.1/RW.12, Mangga Dua Sel.,...
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers