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

Archives: March 2014

Table Space updated again

Today we have another update for an age old script on this site.  You can find the last update to the script here.

This time we have a bit of a bug update.  The details of that bug are in the notes for the script.

Read more

0 comments, 162 reads

Posted in SQL RNNR on 28 March 2014

SQLServerCentral Editorial: The Perfect Environment

I write editorials once or twice a month for SQLServerCentral and have fallen out of the habit of mentioning them here, so trying to resume doing so. Today it’s The Perfect Environment, which is, as you might guess, discussing to what degree you strive for perfection and how far… Read more

0 comments, 114 reads

Posted in SQLAndy on 28 March 2014

Building the SQLSaturday Orlando Marketing Plan–Part 1

I’ve volunteered to lead the marketing effort for SQLSaturday Orlando this year. Broadly speaking that means drive attendance to the main event as well as any seminars we host on Thursday or Friday. We’ve hit a cap the last few years, never getting beyond the 275-300 range (I’ll get exact… Read more

1 comments, 103 reads

Posted in SQLAndy on 28 March 2014

Can’t See The Forest For the Logins–Question of the Day

My latest question is live today – Can’t See The Forest For the Logins is worth 2 points if you’re playing for score. It’s another question where you have to infer some to get the answer. So far it’s proving to be a tough question, be sure to read the… Read more

0 comments, 90 reads

Posted in SQLAndy on 28 March 2014

Friday Followup For March 28, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Cheating DBCC To Fix Index Corruption
  • Automated Permissions Auditing With Powershell and T-SQL: Part 1
  • Building The Redneck…

Read more

0 comments, 100 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 28 March 2014

South Alabama Day of .NET 2014

About 200 miles east of Baton Rouge there lies a beachside town called Mobile, AL that will settle down long enough from spring break to host the first South Alabama Day of .NET at the University of South Alabama. The wife and I are looking forward to presenting at the…

Read more

0 comments, 118 reads

Posted in SQL Tact on 27 March 2014

Getting RUN back in Windows 8

Recently I heard a few people that note that they were really hoping the next update for Windows 8 will bring back the “Run button”, which was available in XP and Windows 7. I guess it was in Vista, but we won’t talk about that fiasco.

I asked a question… Read more

0 comments, 161 reads

Posted in The Voice of the DBA on 27 March 2014

PASS Summit 2012 session videos online

All PASS Summit 2012 recordings are now available for free to all PASS members (201 of them!).  To view, log on to your myPASS account, and watch the sessions from myRecordings.  While there, check out mine: Building an Effective Data Warehouse Architecture

Read more

0 comments, 246 reads

Posted in James Serra's Blog on 27 March 2014

Tally Tables in T-SQL

The Tally (or Numbers) table is one of the most useful constructs in intermediate-level SQL. Have you ever written a T-SQL WHILE loop? How about a CURSOR? If your answer to either of those questions is yes, you’ve probably been coding some really poor-performing SQL and you may not even… Read more

2 comments, 217 reads

Posted in DwainCSQL on 27 March 2014

Quick Tip: Migrating a SQL Server Mirroring Witness server.

If you’re like me, you might be thinking “I want some more things to think about when I migrate between SQL Servers.” … No? Okay, fair enough. There’s a whole list of things to think about when migrating from one SQL instance to another including:

  1. Logins.
  2. Jobs/Alerts/Operators.
  3. Credentials/Proxies.
  4. Linked Servers.

Read more

1 comments, 169 reads

Posted in Ctrl-alt-geek on 27 March 2014

Two IDs, One database and a Magic Number (and maybe even an empty string)

G’day,

I noticed something odd recently when looking at sys.dm_exec_requests. Specifically the system processes listed in that DMV – well at least I thought it was odd

Normally, I join with sys.dm_exec_sessions and filter out anything that is a system process (WHERE [sys].[dm_exec_sessions].[is_user_process] = 1 )

However, this time… Read more

0 comments, 207 reads

Posted in measure twice, cut once. on 26 March 2014

SQL Scripts Manager

We have Down Tools Week multiple times per year at Red Gate. This allows various employees to spend a week on a project, working to build something new and interesting that we rarely have time to spend our limited resources on. Past projects have resulted in SQL Search, a mobile… Read more

0 comments, 1,419 reads

Posted in The Voice of the DBA on 26 March 2014

Zap Business Intelligence Installation

This walkthrough helps you to install Zap Business Intelligence. Some of you may need help knowing where to download the files. This is where I can help you. Firstly, go to www.zapbi.com Go to the download section and download the installation file. Run setup: Setup the connection details: Setup IIS…

Read more

1 comments, 260 reads

Posted in Terry's Business Intelligence on 26 March 2014

Speaking at OPASS – April 2014

If my blog history is correct the last time I presented at oPASS was January 2012 – that seems like a long time ago! I’ll be back at oPASS in April doing two presentations (to make up for missing 2013!):

Building A Learning Plan

What should you learn next? How…

Read more

0 comments, 134 reads

Posted in SQLAndy on 26 March 2014

SQL Saturday Oklahoma City precon: Becoming an Enterprise DBA

We’ll be at OKC this summer for their SQL Saturday on August 23, and we’re presenting our precon “Becoming an Enterprise DBA” August 22!.  Get your early bird ticket by July 15, and save over 15%! Precon: Becoming an Enterprise DBA August 22, 2014, Norman Technology Center, Moore OK There’s…

Read more

0 comments, 167 reads

Posted in SQL Awesomesauce on 26 March 2014

The Unusable User–Question Of The Day

My latest question The Unusable User is live today over at SQLServerCentral. It’s a three pointer, how is that for an incentive to give it a try? Here are the early stats, it’s definitely a hard question (or badly written? nah):

 

 

I’ll post follow up on… Read more

0 comments, 126 reads

Posted in SQLAndy on 26 March 2014

Collation: Expression

I had a recent run in with collation problems and it got me started reading. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

Once you have… Read more

0 comments, 996 reads

Posted in SQLStudies on 26 March 2014

Collation: Expression

I had a recent run in with collation problems and it got me started reading. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

Once you have… Read more

0 comments, 23 reads

Posted in SQLStudies on 26 March 2014

Getting an INDEX SEEK to Speed up LIKE “%string%” Searches

In today’s blog I will attempt to challenge the popularly held notion that LIKE “%string%” wildcard searches must be slow (Sargability: Why %string% Is Slow).

A Sample Table Populated with 10 Million Rows of Test Data

In order to do this, we’ll need a large table of test… Read more

2 comments, 87 reads

Posted in DwainCSQL on 26 March 2014

Conditional Coloured Bar Charts in Excel with Upper and Lower Targets

I was just trying to gauge my BI knowledge level the other day and decided to chart it for visibility. It should be able to tell me to focus on certain topics if 1) I know 20% or less of the topic and 2) if it reaches 100% – which…

Read more

1 comments, 162 reads

Posted in Terry's Business Intelligence on 26 March 2014

Newer posts

Older posts