List SQL Server Instances using Powershell and Get-ItemProperty
This post explains how to list SQL Server Instances installed on the current server, using the Powershell Get-ItemProperty Cmdlet.
The Get-ItemProperty...
2012-02-04
2,678 reads
Delivering Three PTI SQL 2012 Firestarter Webcasts
I have been given the opportunity to deliver a few webcasts about some of the new features of SQL Server...
2012-02-03
1,362 reads
..This operation must be performed in the master database."
"Cannot alter a server audit from a user database. This operation must be performed in the master database."
If you're trying...
2012-02-03
1,094 reads
Re-blog – January 27 – February 2
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-02-03
580 reads
Slowly Changing Dimensions
When designing a data warehouse, how you handle changes to dimensional data over time is the most important decision to make. It...
2012-02-03
1,242 reads
How to output from invoke-sqlcmd to Powershell variable
Sorry for another Powershell post but I’ve been doing a lot of it recently and coming up with (what i...
2012-02-03
21,165 reads
Magazines I Read This Year
In December I went through my current magazine list and made some changes, mostly based on what I had been...
2012-02-03
649 reads
A Script A Day - Day 3 - Live Change Data Edit Template
Today's script is a template I use for the occasions when a data edit is required to be run against...
2012-02-03
576 reads
Pragmatic Works Has Balls...SQLBalls
http://www.flickr.com/photos/54296260@N05/6036813377/
That is right Dear Reader, I am making the jump, Starting Monday February 6th I will be a Sr. Consultant...
2012-02-03
925 reads
Recovery Modals in SQL Server
Being a SQL Server DBA, one should be able to understand how many recovery modals do we have in SQL...
2012-02-03
826 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers