Top BI Enhancements for SQL Server 2012 Presentation Slides
Thanks to everyone who attended my session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting.
Here...
2013-03-13
997 reads
Blog Posts
Building My Next Workstation–Part 6 (The End)
Let’s start with a quick review of the pieces and what I paid:
ItemCostAntec P280 Case$90 (may be higher now)ASUS P8Z77-V...
2013-03-12
667 reads
Day 30 of 31 Days of Disaster Recovery (T-SQL Tuesday #40): Using Partial Availability and Initialize from Backup to Replicate a Partial Database
It’s been a tough and long road to 31 Days of Disaster Recovery. It’s been very difficult coming up with...
2013-03-12
1,342 reads
Installing SQL Server 2012 on Windows Server 2012
Everyone knows that installing SQL server requires .Net frameworks 3.5, and it normally install by default, when you run the...
2013-03-12
589 reads
Parallel Data Warehouse (PDW) Version 2
Version 2 of Parallel Data Warehouse (PDW) is apparently due this month (and can be ordered as of March 1st). The official...
2013-03-12
2,708 reads
Script to clean up “Windows” logins no longer in AD
I was scanning http://dba.stackexchange.com and ran across the following question:
http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory
Basically the OP wanted to know how to get rid of...
2013-03-12 (first published: 2013-03-01)
4,160 reads
SQL RAP
Technorati Tags: SQL Nexus,SQLDiag,PSSDiag,PAL,SQL RAP,SQL Server 2012,SQL Server 2005,SQL Performance
About one year ago I had a Microsoft Premier Field Engineer...
2013-03-12
7,877 reads
SQL Saturday 194
On the weekend of the 9th March 2013, the second SQL Saturday in the UK occurred. A massive thank you...
2013-03-12
661 reads
SQL Server : Index Part 3 :Explaining the Clustered Table Structure
In SQL server, there are two types of table based on the storage.A table with clustered index is called Clustered...
2013-03-12
2,856 reads
Three cheers for SQL 2012 Analysis Services
I had some sales reports that were running poorly on SQL 2005 Analysis Services. The information on the reports was...
2013-03-12
685 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers