Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Archives: September 2013

Microsoft Hyper-V 2012 R2 Enhancements That DBAs Should Care About

The last couple of months have shown that the hypervisor battles for bigger, faster, and smoother are still heated and great for the consumer. Recently Microsoft announced the upcoming release of their virtualization suite, Hyper-V 2012 R2, and the enhancements are great. Let’s explore the updates and new features… Read more

0 comments, 1,706 reads

Posted in Technobabble by Klee from @kleegeek on 26 September 2013

SQL Server 2014: Partition Improvements

SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild.  This will greatly increase enterprise application availability by reducing maintenance downtime impact.

The two new features are:

  • Managed Lock Priority: This allows you to manage the priority of table locks acquired by partition SWITCH…

Read more

0 comments, 478 reads

Posted in James Serra's Blog on 26 September 2013

PASS Votes

I’ve already made my own intentions clear. I’m casting one of my votes for Allen Kinsel. But, I get three votes. Some of you may be asking yourselves, why didn’t recommend two other candidates?

Honesty time.

First, no one else asked me to. I’m actually glad of this. If… Read more

1 comments, 210 reads

Posted in The Scary DBA on 26 September 2013

Images, charts, indicators and sparklines in a tablix stretch and degrade report performance

This fact is probably not documented very well but this is an important factor in SSRS visual report design… The use of rectangles is very much a core part of Reporting Services report design and a difference in behavior is expected.  Cells in a tablix will grow vertically to accommodate…

Read more

3 comments, 321 reads

Posted in SQL Server BI Blog on 26 September 2013

Performance Tuning In LA!

Hello Dear Reader!  This year Pragmatic Works has brought our Performance Tuning Workshop to Chicago, Boston, and Atlanta.  Due to the success we've added one more stop before the end of the year, Los Angeles!

That's right Pragmatic Works is headed to the City of Angels on December 9th -…

Read more

2 comments, 217 reads

Posted in SQLBalls on 26 September 2013

Which personal traits should a #SQLPASS Director have?

A lot has been said about what each candidate would like to do and their track record of delivering in the past. Every candidate has an impressive list of references, you can read mine here. The problem with stating our goals now is it is not like a pledge…

Read more

0 comments, 313 reads

Posted in Richard Douglas on 26 September 2013

I Just Voted in the PASS 2013 Election

I feel like it’s been a good election cycle. Good set of candidates, good discussions, lots of good blog posts from the candidates and their supporters, and some attempts to better inform voters via the online town halls and twitter chats.

I decided on my final candidates last night– it… Read more

0 comments, 217 reads

Posted in SQLAndy on 26 September 2013

Detaching a database

In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL to find out how to detach a database. Dropping a database is easy enough.

DROP DATABASE <databasename>

But that also deletes the database files (unless the database or one of… Read more

1 comments, 1,181 reads

Posted in SQLStudies on 26 September 2013

Monday Night Networking at the 2013 PASS Summit

For the fourth year Steve Jones and I are hosting an informal networking dinner on Monday night at the PASS Summit. We’ll be at Buffalo Wild Wings this year near the Convention Center from 6 to 9 pm. An added bonus this year is that beginning at 7:30 pm they… Read more

0 comments, 531 reads

Posted in SQLAndy on 25 September 2013

Houston Tech Fest 2013

I am traveling (driving) with the family to Houston to present on SSIS 2012 at Houston Tech Fest 2013 at the Reliant Center. The session in the first of the morning in the database track. SSIS 2012 has lots of new features, but this presentation focuses Change Data Capture component,… Read more

0 comments, 224 reads

Posted in The Smiling DBA on 25 September 2013

AdventureWorks2012 Bug on Azure

While I have production databases in Azure, I can’t exactly experiment with them at will. Further, while they mostly have pretty innocuous data, it’s not all public. So, I need a mechanism for creating a database that I can play with in Azure. I use AdventureWorks. I get it. It’s… Read more

0 comments, 488 reads

Posted in The Scary DBA on 25 September 2013

It’s Election Season

It’s that time of the year again – time to make your voice heard as a PASS member.  The PASS board elections are upon us, and if you’ were a PASS member as of June of this year, you should receive your ballot via email tomorrow.  Remember that this year’s… Read more

0 comments, 274 reads

Posted in Tim Mitchell on 25 September 2013

I’m Voting for Allen Kinsel

As you can see from the title of this post, I’ve decided on one of the three votes I’ll be casting in the PASS Election this year – I’ll be voting for Allen Kinsel. I wrote a letter of recommendation for him to be included in his application. Here… Read more

1 comments, 225 reads

Posted in SQLAndy on 25 September 2013

Microsoft + Oracle = New opportunity…Windows Azure is a happening place !

Couple of months back(To be specific in June) Microsoft and Oracle announced their partnership to help enterprise customers embrace the cloud.

It was almost clear that Oracle was going to be available in Windows Azure under the IaSS platform(Virtual Machines’),and today during one of the Oracle Open World keynotes this… Read more

0 comments, 509 reads

Posted in on 24 September 2013

List all mapping users of SQL login account

Find a useful system store procedure to list all mapping user of SQL login account.

sp_msloginmappings @Loginname , @Flags

@loginname: the login account name, If loginname is not specified, results are returned for the login accounts
@Flags: value can be 0 and 1, by default 0. 0 means show mapping user in…

Read more

0 comments, 2,262 reads

Posted in James' SQL Footprint on 24 September 2013

PASS BoD Election Questions – Summit location

As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for the PASS Board of Directors.

As part of the process PASS has invited it’s members to write questions in the  PASS Board of Directors forum. Andy Warren… Read more

0 comments, 245 reads

Posted in Richard Douglas on 24 September 2013

Can You Compress a Temp Table?

 Hello Dear Reader!  We are finishing up the final day of the Performance Tuning Workshop here in Atlanta and I got an interesting question on Compression from Tim Radney (@tradney | Blog).

The question: Can you compress a temp table? Just a quick blog to get the answer…

Read more

5 comments, 2,434 reads

Posted in SQLBalls on 24 September 2013

SQL Server Diagnostic Information Queries for September 2013

I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. I have also added a new version for SQL Server 2014.

Rather than having a separate blog post for each version, I’ll just put the links…

Read more

1 comments, 512 reads

Posted in Glenn Berry's SQL Server Performance on 24 September 2013

PASS BoD Election Questions – Global Vs Local

As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for the PASS Board of Directors.

As part of the process PASS has invited it’s members to write questions in the  PASS Board of Directors forum. TJay Belt… Read more

0 comments, 269 reads

Posted in Richard Douglas on 24 September 2013

Data Warehouse vs Master Data Managment

Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM).  Below is a good list of how they differ.  Note the typical scenario is the data in a MDM database is fed into a DW.

More info:

Master Data Management vs Data Warehousing Read more

0 comments, 604 reads

Posted in James Serra's Blog on 24 September 2013

Newer posts

Older posts