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

Latest Blog Posts

Azure SQL Database monitoring

Even though an Azure SQL Database stores all data on the Azure cloud, it does not mean that your options for managing and monitoring the databases are limited compared to on-prem databases.  In fact, the options available are very similar to on-prem, including 3rd-party products that support Azure SQL databases.… Read more

0 comments, 84 reads

Posted in James Serra's Blog on 10 February 2016

CROSS APPLY v InLine Functions

While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which is done with the HASHBYTES function in SQL Server. This is a computation and given the problem, there is no good way to do this without brute force. The problem… Read more

0 comments, 43 reads

Posted in The Voice of the DBA on 10 February 2016

Leadership and the Data Professional

 

Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in this blog post are ones that have helped me on my journey not just in a leadership role, but from a data professional perspective as well.

I debated often… Read more

0 comments, 45 reads

Posted in The SQL Professor on 10 February 2016

Changing to simple recovery to clear the log.

Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries and blog posts. Because of that I’m not going to talk about the correct methods of dealing with a transaction log full error. What I want to discuss is why… Read more

2 comments, 37 reads

Posted in SQLStudies on 10 February 2016

View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now Available!

Earlier today I had the please of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power BI and time calculations! There were a bit of audio issues on my end but thankfully we were able to still have a great event with lots of great questions! Read more

0 comments, 77 reads

Posted in SQL with Dustin Ryan on 9 February 2016

VMware vExpert 2016 Announcement

What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m honored to say that I have been recognized as a vExpert for the third year running.
I also want to announce that more folks than ever…

Read more

0 comments, 98 reads

Posted in Technobabble by Klee from @kleegeek on 9 February 2016

and other pointless query rewrites

In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to a Column > 2 or Column < 2 combination, it can use indexes better.”

Sounds like something that clearly needs testing!

I’ll start with simple numbers table.

CREATE TABLE…

Read more

0 comments, 92 reads

Posted in SQL In The Wild on 9 February 2016

How Much Hospitals Charge For The Same Type Of Cases?

How much hospitals charge for the same type of cases compared with the average across the US and other cities around the world (limited data)?

The data used in this analysis may be old but it does give us a hint of how much more or less hospitals are charging… Read more

1 comments, 103 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 9 February 2016

Spring Training: Developing SQL Queries for SQL Server

Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries for SQL Server course in Learning Tree’s London Education Centre.

It’s a four day course starting on Tuesday 19th April and will complete on Friday 22nd April.

Its a really… Read more

0 comments, 55 reads

Posted in The SQL DBA in the UK on 9 February 2016

Memory Fundamentals for SQL Server - Process-Thread Model, CPU execution model, CPU scheduling, CPU Architechture, SQLOS

Until now we have seen the windows memory addressing concepts.

http://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-awe.html

So how exactly are user applications like SQL server assigned to this space. To understand this we need to see how the application is broken in terms of processes and threads.


Process


A process is an instance of…

Read more

0 comments, 64 reads

Posted in Kruti's SQL Blog on 9 February 2016

Limitation of In-Memory OLTP in SQL Server 2016 – Seed and Increment value other than 1 not supported

Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than …

Continue reading Read more

0 comments, 115 reads

Posted in Kapil Blogs on 9 February 2016

Upcoming SQL Saturday Precon Sessions (Update!!!!)

Wow, Power BI is making a tidal wave in the BI industry.  New features are being released regularly and blog posts are flying across twitter.  How can you keep up?  Well, if you are in Tampa, FL or Richmond, VA join me in one of these two full day sessions… Read more

0 comments, 60 reads

Posted in SQLDownSouth on 8 February 2016

Introduction to SQL Server: The Main Components

There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a new person just starting a career as a data professional using Microsoft's SQL Server data platform could use to learn all about the product. This made me think I written… Read more

0 comments, 116 reads

Posted in The SQL DBA in the UK on 8 February 2016

SQL Server 2016 Row-level Security and SSRS a perfect match

In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level Security (RLS) with SSRS.  Detailed steps including the TSQL script and SSRS project is provided at the end of this post.  To get started, you need to setup RLS.… Read more

0 comments, 121 reads

Posted in SQLDownSouth on 8 February 2016

Impersonation can give you the wrong answer

I use impersonation all the time to let me see additional permissions information I can only get that way and, sometimes to help me see what permissions error someone is getting.

For those of you who aren’t aware, with the right permissions you can impersonate another principal (server or database)… Read more

1 comments, 98 reads

Posted in SQLStudies on 8 February 2016

T-SQL Tuesday #75 Invitation: Jump into Power BI!

Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI! If you’re reading this and thinking “crap, I’m not a BI person!”, don’t you fret. My intention is to make folks who normally don’t use BI on a day to day basis… Read more

2 comments, 75 reads

Posted in SQL Chicken on 8 February 2016

Database Log VLFs

Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files work in the background.  These are created automatically, but automatically doesn’t always mean perfect.  Here’s a practical view of what you need to know and how you can set them… Read more

0 comments, 74 reads

Posted in Simple SQL Server on 8 February 2016

Friend of Redgate 2016

I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and enables us to participate in the conversation around product and community development.

Last year was my first year… Read more

0 comments, 132 reads

Posted in Anthony Nocentino's Blog on 7 February 2016

Gartner Magic Quadrant for BI/BA and the Lone Three Leaders

History clearly confirms that good things come in threes.  As far as I know this is the first time that only the three most widely recognized Business Intelligence platforms have been placed in the top-right leaders/visionaries space of the Magic Quadrant for Business Intelligence and Analytics Platforms, as of February…

Read more

1 comments, 169 reads

Posted in SQL Server BI Blog on 5 February 2016

Power BI Publish to Web for Anonymous Access is Here

Earlier this week on Wednesday the Microsoft Power BI made an incredibly exciting announcement and released Power BI “publish to web” as a preview feature. This is HUUUUGE news! This was probably the top requested feature and its finally here thanks to the hard work and dedication of the Microsoft… Read more

0 comments, 186 reads

Posted in SQL with Dustin Ryan on 5 February 2016

Older posts