What I Wish I Had Known Sooner…as a DBA
Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came...
2014-08-28
1,121 reads
Blog Posts
Presenting At OPASS August 2014 Meeting On 8/28
Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User...
2014-08-27
1,198 reads
SSIS GoogleAnalyticsSource 1.7
A couple of days ago, Tillmann has released a new version of his amazing SSIS data source for Google Analytics...
2014-08-27
1,256 reads
Stupid me #4 – The login is from an untrusted domain
After quite a while it has finally returned: another Stupid Me™®©! A reminder:
Every time I do something “stupid”, which happens...
2014-08-27 (first published: 2014-08-21)
7,375 reads
Clustered Columnstore Indexes – part 39 (“Memory in Action”)
Continuation from the previous 38 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
In this post I shall try to discover more interesting information about...
2014-08-26
608 reads
Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the...
2014-08-26
16 reads
Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...
2014-08-26
714 reads
Playing with Pivot
I’ve been working on some skills, trying to grow some of my T-SQL, and started to mess with the PIVOT...
2014-08-26 (first published: 2014-08-18)
8,206 reads
SQLSaturday Orlando Marketing Plan-Part 39
Registration is 332 as of 8 am on August 26. We added a whopping 40 registrations last week – a very...
2014-08-26
1,070 reads
Using indexed views on ANY core SQL server edition
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-08-26
175 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers