MDS: Copying models and data to another server
Having recently completed a model in Master Data Services (MDS), I needed to move the model from a development environment...
2012-10-23 (first published: 2012-10-16)
6,049 reads
Lost in Translation – Deprecated System Tables – sysforeignkeys
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-19 (first published: 2012-10-16)
1,771 reads
RML Utilities and SQL Server 2012
I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...
2012-10-16
1,480 reads
Create Several Shell SSIS Packages In Minutes Using BIML
What do i mean by shell packages? You’re spot on – that’s an excellent question to begin with. For the purpose...
2012-10-22 (first published: 2012-10-16)
4,677 reads
Which SQL Instance is Killing Your CPU?
You have 5 instances running. How do you know which one is killing your CPU?
As you can see from Windows...
2012-10-16
562 reads
SQL Server 2012 RTM Cumulative Update 4
Microsoft has released SQL Server 2012 RTM Cumulative Update 4, which is build 11.00.2383.0. By my count, there are 25...
2012-10-16
1,738 reads
SSAS #28 – Setup to Learn SSAS Stored Procedures
Having worked with SSAS for a while and done some reporting with MDX queries, I started to explore opportunities to...
2012-10-16
1,556 reads
Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to...
2012-10-15
45 reads
Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data...
2012-10-15
1,827 reads
Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers
Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...
2012-10-15
419 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I