SQL Saturday NYC Update 1
It has been one week now since SQL Saturday NYC was announced and the planning committee and myself are very...
2014-12-03
375 reads
The Modern Data Warehouse
The traditional data warehouse has served us well for many years, but new trends are causing it to break in...
2014-12-10 (first published: 2014-12-03)
11,569 reads
SSRS SharePoint Integrated Mode – Report Server URL
This is a short, but hopefully sweet post for someone, whom, like me, might have had to end up spending...
2014-12-03
2,713 reads
T-SQL Tricks – Customizing SSMS Templates with Parameters
I wrote briefly about templates in Management Studio (SSMS), and showed the default templates that come with SQL Server. I...
2014-12-11 (first published: 2014-12-03)
7,056 reads
On Perspective
Perspective can make or break a career. Maintaining a proper perspective is very often the differentiating factor between a good...
2014-12-10 (first published: 2014-12-03)
5,662 reads
INSERT INTO SELECT vs SELECT INTO
INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and...
2014-12-03
17,051 reads
Create your own SQL Tools with PowerShell and Windows Forms
Steve:
Check out a new blogger who is sharing secrets of the DBA world. In his first post, James shows us...
2014-12-09 (first published: 2014-12-03)
7,247 reads
Clustered Columnstore Indexes – part 45 (“Multi-Dimensional Clustering”)
Continuation from the previous 44 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
I have blogged a couple times (part 29 – “Data Loading for Better...
2014-12-02
367 reads
Preparing a Technical Session Part 1: Picking a Topic
So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you...
2014-12-12 (first published: 2014-12-02)
5,402 reads
Preparing a Technical Session Part 1: Picking a Topic
So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you...
2014-12-02
826 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