Archives: October 2011
Actually, I only submitted the winning entry;
Denali CTP3 SQL Server 2012 is the real winner. After having a blog posted here recently about running totals performance in Denali CTP3 SQL Server 2012, I happened to run across this T-SQL Challenge for doing running totals. On a lark, I posted… Read more
Today I want to talk about a specified wait type that can be sometimes very hard to
troubleshoot: the THREADPOOL wait type. This wait type is specific
to the internal thread scheduling mechanism inside SQL Server.
As you might know SQL Server internally uses its own "operating system" to implement… Read more
Let’s take a look at how to import the Microsoft Best Practice Policies into your Policy Based Management Server. You can also import policies that you have exported from other servers. The Microsoft Best Practice Policies are a great place to start learning what you can do with PBM, by… Read more
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011.
Databases are built to store data. That’s the primary purpose, and in SQL Server, we store data in a relational form. That means that… Read more
As life skills go one of the hardest is to see yourself as others do – they apply all kinds of filters and interpretations, and of course we’re often reluctant to let go of our own biases that filter our own vision. It’s easy to get hung up on the… Read more
One of the greatest things about all the DMOs is how you can combine the information they present to you with execution plans. It allows you to see what a query is doing, even as it’s executing, because the plan is created first. I couldn’t possibly emphasize enough how important… Read more
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into cacti. The procedure was pulling data from a rather large table, which I had made sure was indexed properly for my query. When I executed the stored procedure from… Read more
There have been a few interesting developments on the hardware front over the past week that I want to cover today. First, Intel has released the new Core i7-2700K processor, which is their new top of the line desktop CPU. It is basically identical to the older Core i7-2600K,… Read more
It’s your career. It’s something you have to take ownership of and work on. I know that life is busy, and training budgets are tight. That’s one reason we started SQL Saturday; it’s a way to bring a training event and a conference experience to many people.
I posted this… Read more
Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product updates as well as give important customers a heads-up on what Microsoft is up to. Participation is by invitation only (usually by someone in Microsoft’s field sales force),… Read more
Today we have another guest post from Steve Jones.
I’m no expert on animals, but I have a little experience out on the ranch in Colorado. Brad appears to be acting very strangely in the latest episode of DBA in Space. The way he’s drinking water is more reminiscent… Read more
When completing an installation I saw the following error – which stopped the installation .
The error occurred during the creation of Indexed View
[2011-10-24 18:21:34.193 02944 error 'App'] A database error occurred: "ODBC error: (42000) - [Microsoft][SQL Server Native Client 10.0][SQL Server]CREATE INDEX failed because the following SET options… Read more
If I could win the DBA In Space contest, I’d be all over it like white on rice. But I can’t win (and yes, that grinding sound you hear is my teeth, not tectonic plates). But, one of my friends might. I already know several of them that have entered. Read more
Microsoft has recently released the SQL Server Developer Training kit for SQL Server 2012. The developers kit includes fantastic resources to learning SQL Server. Download it here.Marc Beacom ...
Last week I emailed the Board of Directors my resignation effective December 31st of this year, ending my current term one year early. It’s a decision I’ve been thinking about since May and explaining it could well consume several posts – though I’m not sure it would be that interesting! Read more
Use this select statement to create a list of ALTER SCHEMA statements for all stored procedures in a SQL Server 2005 database. “dbo” can be changed to whatever schema name required
SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + p.Name
FROM sys.Procedures p INNER…
One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using the Execute Package task. Open the Execute Package Task Editor and select Package from the left window. Select Project Reference for the ReferenceType property.
Now you can reference any package…
This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by Microsoft and other partners. Per GiveCamp’s website:
GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and web strategists…
Same functionality but obvious differences
If you’ve worked with SSIS for any amount of time, you may quickly come to find that the native way of deploying packages can be…cumbersome. The native tools, while helpful, aren’t exactly the most intuitive to setup or use. This post will show you how… Read more
I’ve seen this come a few times at work and I’m sure most you have experienced something similar.
Someone or an application installs SQL Server, doesn’t grant access to the DBA group and asks for DBA support.
In SQL Server 2008 and higher the built-in local administrators group is no… Read more