SQL 2016 Temporal Tables By Example
Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...
2016-04-15
83 reads
Goodness-of-Fit Testing with SQL Server Part 7.2: The Lilliefors Test
By Steve Bolton
…………Since I’m teaching myself as I go in this series of self-tutorials, I often have only a vague...
2016-04-25 (first published: 2016-04-15)
1,669 reads
MongoDB – How to Copy Database
Using copydb
Run the copydb under admin database with from,to, host parameters
>use admin
switched to db admin
> db.runCommand({ copydb: 1, fromdb: “test”,...
2016-04-14
667 reads
Basic SQLCMD–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-04-14
961 reads
Changing Of the Guard
As many of you know, I stay very active within the PASS community. In late 2007 I got my start,...
2016-04-14
495 reads
The Next Chapter ~ A SQL Journey
The past five years have been nothing short of an amazing ride on this thing we call “The SQL Journey”....
2016-04-14
419 reads
Upcoming Speaking Engagements
The next few months will be crazy for me. I will be travelling a lot around Europe, speaking about SQL Server topics.
Here is where...
2016-04-14
465 reads
Cool Tools: Powershell ISE-Steroids
Disclaimer: I have been provided with a free license because I am reviewing. This doesn't impact my assessment of the...
2016-04-14
1,254 reads
Analytics Platform System (APS) AU5 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU5),...
2016-04-14
872 reads
Modulo!
I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even...
2016-04-14
504 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers