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
1,004 reads
T-SQL Tuesday #40– File and Filegroups
It’s the second Tuesday of the month and time for T-SQL Tuesday again. This is a monthly blog party, where...
2013-03-15 (first published: 2013-03-12)
2,861 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,892 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,717 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,881 reads
SSIS 2012 Deadlock When Running SSIS from SQL Agent Job
I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with...
2013-03-18 (first published: 2013-03-12)
5,082 reads
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
668 reads
Do You Know sys.dm_exec_text_query_plan?
One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan.
This Dynamic Management Function allows us to see...
2013-03-19 (first published: 2013-03-12)
2,809 reads
T-SQL Tuesday #40 - Proportional Fill within a Filegroup
T-SQL Tuesday #40 is underway, and this month's host is Jennifer McCown (blog|twitter). The topic is about File and Filegroup...
2013-03-15 (first published: 2013-03-12)
2,897 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
687 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers