-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Adding a T-SQL Job Step to a SQL Agent Job with PowerShell

In my last post, I explained how to alter an existing job step across many servers. I also had cause to add a T-SQL Job step to a large number of jobs as well. This is how I did it.
As before I gathered the required jobs using Get-SQLAgentJob… Read more

0 comments, 32 reads

Posted in SQL DBA With A Beard on 20 February 2017

SQL Cruise 2017 – Western Carribean – my experience

As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is a training(&-vacation for some) event organized by Tim Ford(b | t ) and Amy Ford (t) that happens twice a year. I went on the first one… Read more

0 comments, 68 reads

Posted in Mala's Data Blog on 19 February 2017

Gartner Magic Quadrant for BI 2017 Top 3 Rankings

This is a different spin on the top three vendor rankings visualized in Power BI.  According to the placement of the chart elements in the “Visionary/Leader” quadrant, Microsoft leads Tableau by a little over 36% in the “Vision Completeness “ score and Tableau beat out Microsoft on the “Ability to…

Read more

2 comments, 201 reads

Posted in SQL Server BI Blog on 17 February 2017

The Costs of Hiring Cheaper Consultants

From time to time, I see posts in forums from people complaining about how much some consultants charge. A really good consultant is never going to be cheap. That’s just the law of supply and demand at work right there. When I was consulting, I had plenty of people balk…

Read more

Friday Reading 2017-02-17

Is it me or is February dragging? Anyway, mixed in with this crazy week I’ve been reading: –

SQL Server vs SQL Server vNext
Henrico Bekker runs through a performance comparison of SQL Server against SQL Server on Linux

What Are FeFETs?
Article about a new memory type (FeFETs) that… Read more

0 comments, 92 reads

Posted in The DBA Who Came In From The Cold on 17 February 2017

CLR Stored Procedure Cannot Be Marked as System Object?

It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored procedure sp_MS_marksystemobject as explained here.

The benefit is that when you put a SP in the [master] database and mark it as system object, this SP can then be… Read more

1 comments, 88 reads

Posted in DBA Philosophy on 17 February 2017

Updates to the Power BI course

Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the excellent feedback that IMDB actually doesn’t like people scraping their website for data. Furthermore, the OMDB API appears to have fallen almost out of funds and is… Read more

0 comments, 92 reads

Posted in Koen Verbeeck on 16 February 2017

Deadlock on ALTER DATABASE

I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you ask? Well, 4-5 system sessions were holding locks on the database (and blocking each other). Which meant I wasn’t able to get exclusive use of the database which is required… Read more

3 comments, 678 reads

Posted in SQLStudies on 16 February 2017

Managing Bad Data

In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL processes, reviewing best practices for application flow to prevent or gracefully recover from a systematic error or data anomaly. In this post, I’ll dig a bit further into that… Read more

0 comments, 118 reads

Posted in Tim Mitchell on 16 February 2017

True story: Encryption in progress stuck

Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was stuck on “encryption in progress” for quite a while. Using the following query I confirmed the following: (source: https://msdn.microsoft.com/en-us/library/bb677274.aspx) My … Continue reading

Read more

1 comments, 119 reads

Posted in All About SQL on 16 February 2017

Resolution of Database Consistency Error in SQL Server

There are so many facilities and amenities in SQL Server along with built-in methods, which assist users in some bad situations. It is possible that sometimes SQL server put the users in annoying circumstances when it becomes very difficult for them to access the database. At such situations, the very…

Read more

0 comments, 173 reads

Posted in SQL Mighty on 16 February 2017

PowerShell Virtual Group of PASS February Newsletter

We had a schedule conflict so today’s meeting will be pushed until next Wednesday.  However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in).

 

In this newsletter:

  • Add SSRS to the SQLServer PowerShell Provider?
  • Tonight: PowerShell ? SQL Server: Modern Database Administration with dbatools

Read more

0 comments, 92 reads

Posted in SQLvariant on 15 February 2017

Viewing container logs

I’ve been going over some demos for a presentation that I’ll be giving this year and I thought I’d write this quick post about something that keeps catching me out…


…but first, a bit of shameless self promotion. I’ll be giving my session on an Introduction to SQL Server &… Read more

1 comments, 140 reads

Posted in The DBA Who Came In From The Cold on 15 February 2017

Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)

Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

Continuing with the spirit of the previous blog post on the string data type limitations I decided to add a couple more items that are showing some current limitations of the Columnstore Indexes and the… Read more

1 comments, 106 reads

Posted in Niko's blog on 15 February 2017

SQL Clone and Encryption

I’ve been testing and working with SQL Clone for the last few months, trying to help the devs at Redgate ensure this product is ready to go when it’s released. I’ve written a few pieces on this blog, and I’ve got a new one up on the Redgate blog that… Read more

0 comments, 337 reads

Posted in The Voice of the DBA on 15 February 2017

Azure Advisor Recommendations

Logging into the Azure portal is a daily task of mine and my eyes light up when I see features in preview mode. With that being said Azure Advisor Recommendations is what I will be writing about today. What is … Continue reading

Read more

1 comments, 113 reads

Posted in All About SQL on 15 February 2017

Power BI in SSRS – T-SQL Tuseday

T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. This month’s host is Matt Gordon (t|b) and his topic is Fixing Old Problems With Shiny New Toys. I’ll be talking about the… Read more

0 comments, 499 reads

Posted in The Database Avenger on 14 February 2017

T-SQL Tuesday #87 – New Way to See Wait Stats for a Single Query

Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems with Shiny New Toys”. The old problem I’m going to talk about is seeing what wait types are experienced by a particular query. If you would like to participate in…

Read more

T-SQL Tuesday #87 – Fixing Old Problems with Shiny New Toys: STRING_SPLIT

Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.

Splitting Strings in SQL

A problem that has plagued SQL developers through the years is splitting strings. Many techniques have been used as more capabilities were added to SQL Server including XML datatypes, recursive CTEs and even CLR. I have… Read more

3 comments, 129 reads

Posted in DataOnWheels on 14 February 2017

Server level database permissions

Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a user (database level principal) on each database and granting it the correct permission. And making sure to grant those permissions to the model database so that future databases have the… Read more

4 comments, 171 reads

Posted in SQLStudies on 14 February 2017

Older posts