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

Latest Blog Posts

Database In Recovery Update

Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when a database is “In Recovery”. When I pulled that script out to try and use it on a SQL 2012 box, I got a nasty error.  Thanks to that nasty… Read more

0 comments, 101 reads

Posted in SQL RNNR on 18 May 2015

Why Test Table MetaData Tests with tSQLt

I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our table. However, since the table could change, and may need to, what’s the value of having a test fail if the table changes?

In my mind, I don’t necessarily want… Read more

0 comments, 95 reads

Posted in The Voice of the DBA on 18 May 2015

Counting the number of rows in a table

Don’t be fooled by the title of this post: while counting the number of rows in a table is a trivial task for you, it is not trivial at all for SQL Server.

Every time you run your COUNT(*) query, SQL Server has to scan an index or a heap… Read more

7 comments, 2,849 reads

Posted in SpaghettiDBA on 18 May 2015

Monday Morning SQL Break – May 18, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

0 comments, 108 reads

Posted in StrateSQL on 18 May 2015

Precon: The Enterprise Scripting Workshop #SQLSaturdayBR

You are cordially invited to a fantastic precon event before SQL Saturday Baton Rouge! The Enterprise Scripting Workshop is on Friday, July 31, and if you register before June 30 you’ll get the Early Bird rate of $99…not bad at all for a full day’s training. Oh, and don’t forget…

Read more

2 comments, 140 reads

Posted in SQL Awesomesauce on 18 May 2015

Come to Us or We’ll Come to You

No, that’s not a threat. It’s an offer to help out.

Redgate Software is very serious about the efforts we’re putting into creating the tools needed to support your Database Lifecycle Management (DLM) processes. DLM is a vital part of supporting both Agile development methods and moving towards an automated… Read more

0 comments, 112 reads

Posted in The Scary DBA on 18 May 2015

Extending your metadata with Extended Properties

Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on a object? Well as it happens you can. Extended properties allow you to add a name/value property to a number of the objects in SQL Server. In fact if you… Read more

5 comments, 90 reads

Posted in SQLStudies on 18 May 2015

How to Move MSDB & Model SQL Server system Databases ?

Steps of Moving MSDB & Model SQL Server system Database to new locaation:-

1) Check current location of MSDB & Model Databases by executing below query

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id in (DB_ID(‘MODEL’),DB_ID(‘MSDB’));

You can also use “Execc SP_HelpDB ‘<DBNAME>’ for these details.

2) Execute… Read more

0 comments, 105 reads

Posted in MSSQLFUN on 18 May 2015

Outlier Detection with SQL Server, part 6.3: Visual Outlier Detection with Reporting Services Plots and SSDM Clustering

By Steve Bolton

…………When the goal is to illustrate how just how outlying an outlier may be, the efficiency with which scatter plots represent distances really can’t be beaten. It doesn’t take any training in mathematics to look at one and notice that a few data points are further… Read more

0 comments, 102 reads

Posted in Multidimensional Mayhem on 17 May 2015

Immersed in SQL Server at SQLskills

Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training is second to none in its quality and intensity. The three courses help you look at SQL Server from different angles and are major parts of my job and likely… Read more

0 comments, 133 reads

Posted in Anthony Nocentino's Blog on 16 May 2015

Quick Installs with Chocolatey–Screen Capture

I have been looking for a new screen capture tool. I used to use Snagit, but it felt too heavyweight and buggy for me. I just need to snag part of a screen for my job and blog. I used Quick Screen Capture, but in Win 8 it didn’t want… Read more

0 comments, 191 reads

Posted in The Voice of the DBA on 15 May 2015

003 – The Data Guild - WaterOx Consulting

Reading Time: 5 minutes

Are you an Apprentice DBA? in WOxPod!, episode # 003 – The...

The post 003 – The Data Guild appeared first on WaterOx Consulting.

Read more

0 comments, 173 reads

Posted in WaterOx SQL on 15 May 2015

I Am Grateful For…

I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so far, little in the way of suggestions for how to take advantage of this information. That however doesn’t change my plans around working on positive thoughts and emotions as… Read more

3 comments, 142 reads

Posted in The Scary DBA on 15 May 2015

How To Get Fired from an ETL Developer Job

Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a lot of ETL code. Some of that code was really good, well-thought-out and carefully executed. Other load processes were – well, let’s just say that they provide plenty of consulting… Read more

4 comments, 1,101 reads

Posted in Tim Mitchell on 15 May 2015

Getting Database Properties – DatabasePropertyEx()

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I had someone ask me a question about security recently, and while working through the answer, I ran across something I didn’t know well: databasepropertyex(). Here’s a few… Read more

0 comments, 160 reads

Posted in The Voice of the DBA on 14 May 2015

Stairway to Virtualization Level 2 up at SQL Server Central

Yesterday the next installment of the Stairway to Virtualization series went live on SQL Server Central! This level focuses on the core “why” questions when it comes to building the ideal SQL Server virtual machine. It focuses on all of the core “why” questions, such as how to configure… Read more

0 comments, 115 reads

Posted in Technobabble by Klee from @kleegeek on 14 May 2015

Speaking at 24 Hours of PASS

I’m thrilled to announce that I’ve been selected to present as part of the next 24 Hours of PASS! The theme this time is “Growing Our Communities” – only those who have never been accepted to speak at PASS Summit were eligible to submit abstracts. From the submitted abstracts,… Read more

0 comments, 148 reads

Posted in The Data Files on 14 May 2015

Powershell for SSRS in SharePoint: Multiple data sources and shared datasets

I thought that I would leave any further attempts to improve my Powershell script that was used to deploy SSRS reports to SharePoint along with creating data driven subscriptions in there (please see my previous blog posts: PowerShell, help me to publish my SSRS reports to SharePoint!, SSRS reports…

Read more

0 comments, 226 reads

Posted in Data Adventures on 14 May 2015

Test first; Mileage may vary;

I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a SQL Saturday before I highly recommend it. It’s a day of free training and networking put on by Pass. The training is done by members of the community who… Read more

2 comments, 105 reads

Posted in SQLStudies on 14 May 2015

Putting Your Head in the Clouds - Microsoft Azure

By David Postlethwaite
Microsoft Azure

Let’s take a look at the Microsoft Cloud offering. Originally called Windows Azure it was renamed in March 2014 to Microsoft Azure to reflect Microsoft now offering more than just Windows. At the time of writing Azure is available in 141 countries, including China, and…

Read more

0 comments, 139 reads

Posted in The SQL DBA in the UK on 14 May 2015

Newer posts

Older posts