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

Latest Blog Posts

Networking and the PASS Summit

PASS Summit 2016 is fast approaching. If you’re going, time to start making plans. If you’re not going, sell your boss on the idea and get registered. It’s only the largest Microsoft Data Platform event on the planet. There are over 200 sessions given by some of the most knowledgeable… Read more

0 comments, 72 reads

Posted in The Scary DBA on 27 September 2016

Is ROI for Vendors Worth the SQL Saturday Investment?

Piggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from my perspective, on how vendors all fit into these events.

Having the opportunity to work alongside these vendors has been both a learning experience for myself along with forming new… Read more

2 comments, 67 reads

Posted in The SQL Professor on 27 September 2016

Quick Tips–Using ii in #SQLPrompt

SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself to use a few of these and not just start to type with your old habits. This quick tip looks at one of those areas when inserting data into tables. Read more

0 comments, 112 reads

Posted in The Voice of the DBA on 27 September 2016

Pinned Tabs

It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) linked to my post Comparing Two Query Plans. Since I always find that interesting I followed the link and wound up at his post 3 Reasons to?… Read more

0 comments, 63 reads

Posted in SQLStudies on 27 September 2016

Part 1 - Detecting and Monitoring Memory Pressure

I will be writing this article in four parts because this topic is huge and amount of information can be overwhelming for readers and for me also. So we will be exploring it step by step. 1.                    DBCC MemoryStatus 2.                    Using DMV 3.                  

Read more

0 comments, 192 reads

Posted in Help on MSBI on 27 September 2016

SSMS 2016& Azure SQL DBs

When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that I noticed when you are connected to an Azure (logical) SQL Server. So below I have 2 screen shots – … Continue reading

Read more

0 comments, 146 reads

Posted in All About SQL on 27 September 2016

SQL Relay 2016

It less than week to SQL Relay - a week long SQL conference that is visiting Birmingham, Cardiff, Reading, Nottingham and Leeds. 

See if you can persuade your boss to let you out to receive some top notch training from industry experts and speakers.

David will be there speaking on…

Read more

0 comments, 60 reads

Posted in The SQL DBA in the UK on 27 September 2016

Future DBA – Hive Big Data 2

In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is quite difficult so with the help of Vendors -Cloudera/Hortonworks/MapR we can integrate the tools/utility in a GUI way and can be … Continue reading

Read more

0 comments, 106 reads

Posted in Vinay Thakur on 27 September 2016

Know Why to Use log_reuse_wait_desc Column In sys.databases


Most of the time, while working with SQL Server, the transaction log files usually grows due to numerous reasons. Out of which one such reason is that there is already existing allocated space to the file in the SQL Server. This can be caused due to natural increment in… Read more

0 comments, 616 reads

Posted in Zora's SQL Tips on 27 September 2016

Query Store and What Happened Earlier On Your Server

Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what happened. Can Query Store tell us?

My first blush response is, no. Not really. Query Store keeps aggregate performance metrics about the queries on the database where Query Store is… Read more

1 comments, 105 reads

Posted in The Scary DBA on 26 September 2016

A Goal of Speaking at PASS Summit

Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty of goals, but none of them involved SQL Server. I really had no idea of where I wanted my career to go other than working in IT. Finally in 2000,…

Read more

0 comments, 82 reads

Posted in Everyday SQL on 26 September 2016

Studying Failures

Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who successfully landed his A320 jet on an icy river after losing both engines shortly after takeoff. I enjoyed the movie for its main story line but also for some of… Read more

0 comments, 110 reads

Posted in Tim Mitchell on 26 September 2016

Nil to Speaker: Improving your PowerPoint skills

As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve been collecting a few links with examples and instructions I have been using to improve my skills.

Some awesome PPT slides by Edwin M Sarmiento (b/t).… Read more

0 comments, 66 reads

Posted in SQLStudies on 26 September 2016

Future DBA – Hadoop Big Data 1

In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on continue to that hadoop is mostly for big data and the on hadoop is stored in HDFS with named node … Continue reading

Read more

0 comments, 137 reads

Posted in Vinay Thakur on 26 September 2016

SQL SSRS Express Edition Cannot Connect to Azure SQL Databases

This has bit a couple of clients recently, figured I'd put out a PSA.

Express editions of SQL Server Reporting Service, from SQL 2016 on down, cannot connect to Azure SQL Databases. Turns out, getting something for free does have some significant limitations.

For example, you'll see an error message…

Read more

0 comments, 89 reads

Posted in SQL Tact on 25 September 2016

PowerShell, Pester and Ola Hallengrens Maintenance Solution

If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and click the link and look at the easiest way to ensure that all of your essential database maintenance is performed. You can also watch a video from Ola at SQL…

Read more

0 comments, 150 reads

Posted in SQL DBA With A Beard on 24 September 2016

Order by Month Number and Show Month Name

This may feel very simple to many developers and yes it is, but I saw this request somewhere in community website.So thought of creating a very simple example.  Here I am using AdventureWorks2014 database, we have table [AdventureWorks2014].[HumanResources].[Employee] and we will use [HireDate] column. I am adding two new columns…

Read more

0 comments, 211 reads

Posted in Help on MSBI on 24 September 2016

11 years of PASS Summit

This is a story of my 11-year association with PASS, and the many ways it helped me grow as a person and in my career. And the many ways I saw other people grow.

 Summit #1 – 2006: Gaylord,TX: I was a visa holding dba-developer at a small shop.… Read more

0 comments, 112 reads

Posted in Mala's Data Blog on 23 September 2016

Announcing SQLSaturday Portugal Lisbon-Edition 2017

With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017 already live! Between 9th and 11th of March 2017 at Microsoft Portugal in Lisbon, the 7th edition of the SQLSaturday…

Read more

0 comments, 175 reads

Posted in Niko's blog on 23 September 2016

Think Using .. In Code Is A Time Saver? Think Again! - Syndication – WaterOx Consulting

Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out there) identify the exact location of the objects in the environment. The 4 part name follows the convention of <server>.<database>.<schema>.<object>. In most cases, you are only going to use the…

Read more

0 comments, 155 reads

Posted in WaterOx SQL on 23 September 2016

Newer posts

Older posts