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

Latest Blog Posts

Let NonAdmins Get Logins

I saw a question recently about how to allow some users to see the logins on a server without being a sysadmin or securityadmin. This was in support of a migration effort, so users needed read rights without being able to change anything.

This appears to be a good place… Read more

0 comments, 299 reads

Posted in The Voice of the DBA on 8 February 2017

Deadlock priority

Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who isn’t. For example, I’m doing a big delete on a table in a 24×7 environment, I can’t afford downtime to do it so I’m doing my delete in small… Read more

5 comments, 1,291 reads

Posted in SQLStudies on 8 February 2017

Speaking at SQLSaturday Chicago – 600!

Speaking at SQLSaturday Chicago!

I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow, 600 SQLSaturdays! This one won’t let you down. Check out the amazing schedule!

If you don’t know what SQLSaturday is, it’s a whole day of free…

Read more

0 comments, 97 reads

Posted in Anthony Nocentino's Blog on 8 February 2017

Power BI Custom Visuals Class (Module 37 – Gap Analysis)

In this module you will learn how to use the Gap Analysis Power BI Custom Visual.  The Gap Analysis visual is used to analyze the difference between two different groups of data you have.  For example, you might use it to analyze the gap between two answers people gave in… Read more

0 comments, 1,156 reads

Posted in Devin Knight on 8 February 2017

Dynamically Changing Shapes in Power BI – Alternatives

NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used in the functions and lists instead of commas. Also, we use the comma as the decimal seperator. 0.95 (in the US) is 0,95 in my locale. A couple of well… Read more

4 comments, 690 reads

Posted in Koen Verbeeck on 8 February 2017

Creating SQL Containers from a Dockerfile

I’ve been playing around with SQL containers on Windows Sever 2016 a lot recently and well, building empty SQL containers is all fine and dandy but it’s kinda missing the point. What containerization allows you to do is build custom images that are designed for your environment, say with a… Read more

3 comments, 1,185 reads

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

Improve performance by replacing temp tables with memory optimized tables - Part 2

Follow my last post which can be found here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/), we discussed about replacing table variable by memory optimized table, this time we will look at another use case - global temp table.

The main idea here is to replace temp tables, where those data does not needs to…

Read more

1 comments, 2,430 reads

Posted in Dennis's SQL Blog on 8 February 2017

Team Productivity Practices – #TAPtips

Ensuring and maintaining team productivity practices is important for any organization, especially a small and growing team. The biggest part of the equation is each individual team member. Hiring productive employees is the foundation of any team or should be.

Here is a list of items I’ve found to be… Read more

0 comments, 171 reads

Posted in Marc Beacom on 7 February 2017

Not Quite Monday Morning SQL Break – February 7, 2017

It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to ensure that I get this out the published.  If you haven’t already, follow me on twitter (@StrateSQL). This is… Read more

0 comments, 127 reads

Posted in StrateSQL on 7 February 2017

Does Query Store Pre-Allocate Space

I love the questions I get while I’m presenting because they force me to think and learn. The question in the title is one I received recently. The answer, now that I’m not standing in front of people, is easy. Of course the space is not pre-allocated. Query Store tables… Read more

0 comments, 811 reads

Posted in The Scary DBA on 7 February 2017

Would You Still Love Linux If Windows Was Free?

How often is cost the deciding factor in the case of Windows vs Linux? And what if cost wasn’t a factor (noting that Linux isn’t “free” if you’re paying a support agreement)? If you look at cloud offerings Linux has an advantage in pricing because its, if not free, considerably… Read more

0 comments, 169 reads

Posted in SQLAndy on 7 February 2017

Dynamically Changing Shapes in Power BI

UPDATE: I also published a blog post using a DAX only approach. Check it out here.

Recently someone had a question if it was possible to change the color of a shape depending on the value of a measure. Imagine for example a dashboard with the picture of a… Read more

9 comments, 1,124 reads

Posted in Koen Verbeeck on 7 February 2017

Restrict user to login from single Host

Restricting user to login from single host may be sometimes required from security point and other business requirements. We can achieve it through SERVER LEVEL LOGON TRIGGER.

ALTER TRIGGER TR_CHECK_LOGIN_TEST_HOST
ON ALL SERVER
FOR LOGON
AS
BEGIN

DECLARE @HOSTNAME VARCHAR(48)
DECLARE @PROGNAME VARCHAR(100)

SELECT @HOSTNAME = HOST_NAME FROM SYS.DM_EXEC_SESSIONS Read more

0 comments, 104 reads

Posted in MSSQLFUN on 7 February 2017

SQL: Different ways to generate sequence

There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3.

Select A =identity(int,1,1),B,C from table_abs

1,A,41

2,B,13

3,C,90

4,D,91

5,E,98

6,F,12

7,G,54

8,H,16

For this output, the 4th column generates the Sequence of numbers… Read more

0 comments, 1,602 reads

Posted in PowerSQL By Prashanth Jayaram on 6 February 2017

Still Grateful to Rodney Landrum

So, my blog got hacked. They edited the page where I thanked Rodney for all that he did. I had to remove that post as a part of the cleanup (still ongoing). However, I couldn’t let that stand. I’ve used caching on the internet to track down the original post… Read more

0 comments, 115 reads

Posted in The Scary DBA on 6 February 2017

SQL Connectivity issues: A guided walk through

The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues.

Announcement
Walk Through

If you look at the bottom of the announcement you’ll also notice links to walkthroughs for

Troubleshooting Always On Issues
Troubleshooting connectivity issues with Microsoft Azure SQL Database

I’m… Read more

0 comments, 117 reads

Posted in SQLStudies on 6 February 2017

Part 2 - Detecting and Monitoring Memory Pressure Using DMV

I will be writing this article in four parts because this topic is huge and the 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, 322 reads

Posted in Help on MSBI on 6 February 2017

Monday Coffee 2017-02-06

A lot’s been said about last week’s Gitlab outage so I’m not going to go over the details here but I do want to talk about one point that was when I was watching the guys fix the issue live on youtube.

A lot of the people making comments kept… Read more

1 comments, 110 reads

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

SQLPort V2

The new site of SQLPort is finally live. This is not just a redesign of the original site, published in April 2010. This is the start of the second approach that we shall start implementing right from the very next meeting, the 91th SQLPort meeting to be held on… Read more

0 comments, 80 reads

Posted in Niko's blog on 6 February 2017

Using Extended Events in Azure

Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace, once you get past the learning curve it’s probably the way to go. If you are operating in the Azure … Continue reading

Read more

2 comments, 762 reads

Posted in All About SQL on 6 February 2017

Newer posts

Older posts