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

Latest Blog Posts

Excel Tip #21: Hiding Scrollbars in Excel Services Web Part

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 101 reads

Posted in DataOnWheels on 17 March 2015

T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable

Prashanth Jayaram:

Added few more examples

Originally posted on Prashanth Jayaram :

On Technet forum, Op was looking for a way to get table cardinality for all databases in an instance.  There are many ways to get the result. This post gives you an idea and SQL in which…

Read more

0 comments, 121 reads

Posted in PowerSQL By Prashanth Jayaram on 17 March 2015

Combating the CXPacket Wait Type

Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of the list.  If this is the case for you as well, chances are your server isn’t on fire, but there could be room for improvement.

What Does It…

Read more

3 comments, 4,953 reads

Posted in Adam Kreul | Blog on 17 March 2015

The Demo Setup–Attaching Databases with Powershell

I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.

TL;DR I have a script that detaches all user databases from a SQL Server instance and then reattches certain ones. Full script at the end.

The Issue

We have a lot of demo… Read more

1 comments, 311 reads

Posted in The Voice of the DBA on 16 March 2015

“Thing IS NOT NULL” isn’t the same as “Thing != NULL”

I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.)  And yet, it’s worthwhile to bring these things up from time to time. “[Thing] != NULL” is nonsense. It won’t work the way you want it to work, because…

Read more

14 comments, 182 reads

Posted in SQL Awesomesauce on 16 March 2015

ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

Great Articles at SQLPerformance.com

There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space.

So, I’ll be arbitrary and simply choose a few of my favorite entries as well look back:

Troubleshooting SQL Server CPU… Read more

2 comments, 122 reads

Posted in Kevin E. Kline on 16 March 2015

Review of Minion Reindex

Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all for making my day job easier so I once I heard about this I wanted to get it into a development environment asap to see what it can do. Unfortunately… Read more

0 comments, 5,092 reads

Posted in The DBA Who Came In From The Cold on 16 March 2015

How To Speak At SQL Saturday Events

The PASS SQL Saturday events are meant to be a place to grow the pool of speakers, provide a mechanism for the speakers to learn, and fulfill the PASS goals of Connect, Share and Learn. So, you’ve decided you want to start speaking at a SQL Saturday event. Cool. You… Read more

8 comments, 106 reads

Posted in The Scary DBA on 16 March 2015

There are #temp tables and then there are ##temp tables.

Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly regular basis. What I don’t think a lot of people know is that there are two types of temporary tables.

  • Local Temporary Tables
    SELECT * INTO #LocalTempTable FROM sys.databases
  • Global…

Read more

0 comments, 115 reads

Posted in SQLStudies on 16 March 2015

Iterating Through Excel Worksheets with Biml

Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in this post by Koen Verbeeck) to addressing multiple worksheets in a single document, configuring SSIS to properly read from or write to Excel documents is tedious at best. While there… Read more

7 comments, 4,572 reads

Posted in Tim Mitchell on 16 March 2015

Date Range Challenge in sql

Hi Folks,


When you work in a offshore - onsite setup in IT industry and if you are fortunate :-) to be a part of the offshore team then there are many compromises that you have to make. Out of those one such is to develop your code based on…

Read more

0 comments, 10 reads

Posted in Everyday IT Challenges on 15 March 2015

How to Replace Multiple Strings in a File using PowerShell

Replace the Data Source and Initial Catalog values of WebConfig.XML

Content of XML file

<Configuration ConfiguredType=”Property” Path=”\Package.Connections[ConnStaging].Properties[ConnectionString]” ValueType=”String”>
<ConfiguredValue>Data Source=localhost;Initial Catalog=Stage;Integrated Security=SSPI; Connection Timeout = 10</ConfiguredValue>
</Configuration>

PARAM(
[String]$DatabaseName='DCTarget',
[String]$XML='c:\webconfig.XML',
[String]$DatabaseServer='

Read more

0 comments, 5,089 reads

Posted in PowerSQL By Prashanth Jayaram on 13 March 2015

SQL Saturday #408 Houston – June 13th 2015

Call for speakers is now open for SQL Saturday #408 in Houston, TX.  If you are interested in presenting please fill out the form – https://www.sqlsaturday.com/408/callforspeakers.aspx.  The call for speakers ends on 4/14/2015.

For complete details on the event see – https://www.sqlsaturday.com/408/eventhome.aspx.

SQLSaturday is a training event for SQL… Read more

1 comments, 171 reads

Posted in Business Intelligence and Enterprise Architecture on 13 March 2015

My First Ever SQL Saturday Pre-Con

Like most people I have a bucket list of things to do before I depart for other things. However I chose to have two bucket lists, one personal and one professional. I’m now one step closer to ticking another one off of my professional bucket list, the title should give… Read more

0 comments, 118 reads

Posted in Richard Douglas on 13 March 2015

Speaker of the Month: February & March 2015

It’s not a question of scheduling. I just haven’t been to lots of community events in the last several months so that I can see community speakers and find one to give an award to. I’ve been trying. So, we’re giving out two awards this month (my blog, my award,… Read more

0 comments, 152 reads

Posted in The Scary DBA on 13 March 2015

SQL Server Virtualization for VM Admins – SQL Saturday Madison Precon

I am pleased to announce a brand new pre-conference training session, entitled “SQL Server Virtualization for VM Admins“, to be launched on Friday, April 10th, the day before the upcoming SQL Saturday event in Madison, Wisconsin. The price is only $100 for the entire day of training! Read more

0 comments, 131 reads

Posted in Technobabble by Klee from @kleegeek on 13 March 2015

Allowing a User to Create Objects in a Schema

I was testing something the other day and realized this was a security area I didn’t completely understand. I decided to write a few posts to help me understand the issues.

I want to give a developer rights to create objects in a schema. In this case, I’ll stick with… Read more

1 comments, 204 reads

Posted in The Voice of the DBA on 12 March 2015

Altering a Column with NOT NULL

A short piece, as I ran into the need recently to alter a column to NOT NULL status. I’ve rarely done this in the past, usually specifying NOT NULL when I create the table. Often in future changes, I’ve been wary of not allowing NULLs since I’ll always find an… Read more

0 comments, 215 reads

Posted in The Voice of the DBA on 12 March 2015

Exam Prep 70-463: Deploying projects in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

1 comments, 649 reads

Posted in Cleveland DBA on 12 March 2015

Monitoring for Timeouts

The question came up at SQL Rally, “Can you use Extended Events to monitor for query timeouts?”

My immediate response was yes… and then I stood there trying to think of exactly how I’d do it. Nothing came quickly to mind. So, I promised to track down the answer… Read more

2 comments, 5,160 reads

Posted in The Scary DBA on 12 March 2015

Newer posts

Older posts