Archives: April 2012
In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced in 2005 solved most of the problems. In 2012, SQL Server Integration Services introduces parameters to make this process even easier. Parameters allow you to change package properties without the… Read more
I came across an issue today where a backup process was in a blocked state with a wait type of MSSEARCH. The issue boiled down to an issue with communication/contention between the SQL Server engine service and the SQL Server Full Text Search service.
An attempt to kill the backup… Read more
In a bold and decisive move earlier today, the University of Florida has decided to dissolve their computer science education program. In a statement to the media, university administrator Angus Pyle defended the groundbreaking but controversial decision. In his remarks, he praised the staff and students involved in the Computer… Read more
What I’d really like to share with you about the event is what a fantastic group this… Read more
The overall opinion seems to be that the 22nm Ivy Bridge represents a relatively small boost to CPU performance (typically 5-20% compared to the 32nmSandy Bridge, depending on the task), a pretty significant boost to integrated graphics performance (typically 40-65% compared to Sandy Bridge), and reduced power consumption under load… Read more
I turned 40 a few years back, and it wasn’t that big a deal for me. In some ways my wife thinks I’m a little old for my age, and when I hit 40, it wasn’t the milestone it is for some people. I think the night I turned 40… Read more
- BIxPress – Audit, Notify, Deploy and Manage SSIS Packages
- BIDocumenter – One Stop Documentation Solution for SQL Server, SSAS, SSRS and…
One last reminder – If you’re interested in learning more about troubleshooting and optimizing SQL Server performance, please consider coming to the full-day seminar I’ll be giving this Friday. Full details are here: http://sqlperftuning.eventbrite.com/. We’ll be working some exercises, so bring your laptop with an instance of SQL Server… Read more
- It’s time to true-up with Microsoft, what are your current license counts?
- Operations needs to schedule maintenance on ServerY, what applications will be impacted?
- A developer wants to change the password for a certain login, what linked servers will be affected?
- Are there any databases that haven’t been…
Here’s the situation. We’re absolutely falling down as men and professionals. Ladies, feel free to read on and comment, but I’m talking to the guys.
This blog post has been percolating in my mind for quite some time, but a few new stories have brought it to the fore. The… Read more
Here’s a quick query that you can run to find out the users with
sysadmin fixed server role. Sysadmins have a complete control of your server. So, it is very important to know who these people are.
Just to give you an example on why it is very important to… Read more
When connecting to a server from SSMS using Windows Authentication, you are limited to using only user which you used to log on to Windows. For example, if you login using User1 on Windows and launch SSMS, you can only use User1 to connect to a server from SSMS as… Read more
I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may be you are interested too. These are all cool people sharing information for free to the community.
- PragmaticWorks Webinars. Training events on the T’s – Tuesday’s…
Web sites, blogs and media outlets in Europe and the U.K. are starting to post some early Ivy Bridge stories, which means that the Intel information embargo about the Ivy Bridge processor must be nearly about to expire. From what I have been able to determine, the information embargo is… Read more
Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is also available now.
After Sql server 2008 (compatibility 10) and sql server 2010 /sql server 2008 R2 (compatibility 10.5) another major release from Microsoft sql server is… Read more
As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can download it here (PDF warning). The complete SQL Server 2012 Licensing Overview is here. The most relevant part of this table regards the newer AMD 31XX, 32XX, 41XX, 42XX,… Read more
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…