SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: January 2014

SQL Server Quickie #10 – Forwarding Records

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I have uploaded the 10th SQL Server Quickie to YouTube. This time I’m talking… Read more

0 comments, 734 reads

Posted in Klaus Aschenbrenner on 29 January 2014

SSIS and PowerPivot training in Baton Rouge

I’m happy to announce that I’ll be teaming up with my Linchpin People colleague Bill Pearson for a day of BI and SSIS training next month.  On Wednesday, February 12th, we’ll each be delivering a full-day presentation in Baton Rouge, after which we’ll be joining the Baton Rouge SQL Server… Read more

0 comments, 860 reads

Posted in Tim Mitchell on 29 January 2014

Reminder: I’m Presenting Security, Compliance, and SQL Server Today at 3PM Eastern

I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more about how to deal with your corporate Security and Compliance teams, and what you can do to keep your databases secure.

Read more

0 comments, 505 reads

Posted in SQLAndy on 29 January 2014

Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I have a blocking situation I like to look and see what query is running that is blocking everything else. I’ve mentioned recently that you can also use sys.dm_exec_connections.most_recent_sql_handle to see… Read more

2 comments, 831 reads

Posted in SQLStudies on 29 January 2014

Master Data Services for the Beginner Part 04



In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on extracting data from Master Data Services, via views.

Getting started

We start off by bringing up the Master Data Manager in the normal manner.

Once again, my link… Read more

0 comments, 1,887 reads

Posted in Simon Says on 29 January 2014

SSIS #116–What is the variable value at runtime?

Using variables in SSIS packages can make your ETL process more dynamic and respond to different scenarios during runtime.

Not only we can use variables, we also have many different ways to set values for our variables. This is all good news for developers. But like many things in real… Read more

1 comments, 6,820 reads

Posted in Sherry Li's BI Corner on 29 January 2014

[SQL Snacks Video] Importance of COPY_ONLY Backups

There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is one that I felt is important to highlight to SQL Server DBAs. This backup is independent backup that is not part of the regular cycled backups that you perform; hint…

Read more

0 comments, 645 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 29 January 2014

SQL Server Data Compression

SQL Server Data Compression Overview

I have been reviewing the options for data compression in SQL Server and believe it can be a great value to Reporting and Business Intelligence databases.  By their nature BI databases typically store more data than any other database in your environment.  Even with the… Read more

0 comments, 1,207 reads

Posted in Business Intelligence and Enterprise Architecture on 29 January 2014

February – Colorado SQL Events

SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are… Read more

0 comments, 395 reads

Posted in Marc Beacom on 28 January 2014

Just use Version Control

There are free systems out there. If you have no budget, and want to get started, download one of these:

There are good ones to pay for as well, and some of them have other features and integration you may like:

  • Team Foundation Server…

Read more

10 comments, 2,849 reads

Posted in The Voice of the DBA on 28 January 2014

SQL Server Data Tools (SSDT) – January 2014 update

The SSDT January 2014 release has been updated to support both SQL Server 2012 Parallel Data Warehouse Appliance Update 1 (AU1) and continues to support SQL Server 2012 Parallel Data Warehouse.  This release of SSDT is now PDW version-aware, and the experience is different when connected to SQL Server… Read more

0 comments, 1,415 reads

Posted in James Serra's Blog on 28 January 2014

Movie Adaptations of Books

I’ve never written a novel or a movie script, but I’ve sure consumed a lot of both and enjoy both. I’ve always been excited when a book I have read becomes a movie. Validation of a sort I guess – I like something popular! But really it’s a chance to… Read more

0 comments, 747 reads

Posted in SQLAndy on 28 January 2014

Virtualization resource consumption counters lie to you

OK, so maybe they do not lie to you, but I got your attention. In virtualized environments, the performance statistics that you see from the management interface may not give you the entire picture, and can lead to bad assumptions or misleading recommendations.

Remember, the virtualization layer does not understand… Read more

6 comments, 2,002 reads

Posted in Technobabble by Klee from @kleegeek on 28 January 2014

Know When it’s Good Enough

Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love performance tuning a lot, and even more, I love challenges. But sometimes taking a query from the “good enough zone” down to “super-performance zone” will take a lot… Read more

4 comments, 671 reads

Posted in Matan Yungman on 28 January 2014

Jan PASS Data Architecture VC presents Ike Ellis on Tips & Tricks

Please join the PASS Data Architecture virtual chapter on Thursday Jan 30th at noon central for SQL Server Tips and Tricks presented in 5 minute lectures.


Next Meeting

Thu, Jan 30 2014 12:00 (GMT-06:00) Central Time (US & Canada)

RSVP: https://attendee.gotowebinar.com/register/2529334496189827586

This is a SQL presentation for the YouTube…

Read more

0 comments, 1,055 reads

Posted in The Smiling DBA on 28 January 2014

If You’re Not Doing Anything….

Hey… Pssst… Yeah, you there on the couch. Listen, if you’re not doing anything around lunchtime on February 6th, I have a suggestion for you.

Displaying a startling lack of good judgement, Dell Software has decided to put me in front of a virtual audience to present my “10 Ways… Read more

0 comments, 596 reads

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

Inside the Statistics Histogram & Density Vector

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)

You know the problem: the “Estimated Number of Rows” in an operator in the Execution… Read more

0 comments, 3,409 reads

Posted in Klaus Aschenbrenner on 28 January 2014

Master Data Services for the Beginner Part 03



In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very loosely compared to a database, an entity to a table and attributes to the fields of a table.

Today we are going to load the raw data(member) into… Read more

0 comments, 5,004 reads

Posted in Simon Says on 28 January 2014

Powershell in a Month Day 13 – Remote Control

This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

Remoting. It sounds complex, and intimidating. It isn’t, and it’s powerful. It’s also essential, allowing you to access commands on remove… Read more

1 comments, 970 reads

Posted in The Voice of the DBA on 27 January 2014

Transact-SQL (T-SQL) query to return the status and detail information for all SQL Server Full-Text Catalogs on an SQL Server instance

We have about 200 user databases in which we have the full-text search enabled and these databases contain several tables. As part of my daily checks, I have to check the status of all full-text catalogs, to ensure that all full-text catalogs are successfully populated without errors. However, to check… Read more

0 comments, 1,368 reads

Posted in Basit's SQL Server Tips on 27 January 2014

Newer posts

Older posts