Archives: April 2012
I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored procedures.
The particular case that I came across today was regarding roles and the ALTER ROLE syntax.
Prior to SQL SERVER 2012, it has… Read more
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at Houston SQLSaturday.
Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes
Scaling SQL Server to HUNDREDS of Terabytes
Learn how SQL Server 2008 can scale to HUNDREDS of terabytes for BI… Read more
here is a great article about how to setup the database mirroring and log shipping together.
In our system, we setup data mirroring with high-safety…
Temporary Post Used For Theme Detection (a2bb2736-7786-4122-aa80-2ea5c4a91819 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (a9a8917a-7430-47c6-8534-f96e3e4e0618 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
I’ll be spending the day with the 2011 Idera ACE’s (aka the old aces) and the 2012 Idera ACES (the new ones!) as we share lessons learned, work on being better at presenting and networking, and in general talk about ways to have a positive impact. Then tonight I’ll be… Read more
Most recently, I put together a .zip file of T-SQL scripts that developers would find handy. You can download it here.
Here's a summary:
Missing Indexes -…
Measuring Internal Fragmentation
In just two days SQL Saturday 107 will be in full swing. Tomorrow begins their precon with the infamous Kalen Delaney. Those who were lucky enough to sign up and get one of the coveted spots are in for a treat. Thanks to the Idera ACE program I was blessed… Read more
I've added the following features:
- The query execution plan of the active request in the QueryPlan column to the right.
- Variable at the top which changes the relationship of the join between sys.dm_exec_sessions and sys.dm_exec_requests.
- When set…
“Why I joined Linchpin People as a Teammate”
It was announced publicly this past weekend at SQL Saturday #111 that I have joined Linchpin People as their first teammate. My friend Andy who is also a Chief Servant Officer of Linchpin made the announcement during the speaker dinner and gave… Read more
Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any component in SSDT whether or not your SQL Server supports that component. For example, you can create a package with Fuzzy Lookup and deploy to a server running Business Intelligence… Read more
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.
Okay, continue with Miscellaneous Info
here is some more important stuff/ information about sql server.
>>Ghost cleanup task runs every 5minuts (in 2005) and runs every 10minuts in (2008… Read more
Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from a table of sequential numbers.
there are 2 monitor tables after logshipping setup
This table has entries for all primary database on primary server and monitor server
This table has entries…