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

Latest Blog Posts

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, 171 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,147 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, 105 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,617 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, 116 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, 120 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, 323 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, 117 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, 81 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, 770 reads

Posted in All About SQL on 6 February 2017

Dark Theme in Office 2013 & 2016

Last week I blogged about how you can turn on Dark Theme in SSMS 2016 but that it’s unfinished and you can use it at your own risk.

As good quality 4K monitors in the 30+ inch range continue to get cheaper & cheaper I find myself wanting to have… Read more

0 comments, 60 reads

Posted in SQLvariant on 5 February 2017

I have been hacked

I’m working on securing the blog. Please stand by. Apologies for any inconvenience or confusion.

The post I have been hacked appeared first on Grant Fritchey.

Read more

3 comments, 310 reads

Posted in The Scary DBA on 5 February 2017

Friend of Redgate – 2017

I’m excited to announce that I have been named a Friend of Redgate for 2017. 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.

As a multi-year awardee in the… Read more

0 comments, 119 reads

Posted in Anthony Nocentino's Blog on 5 February 2017

SQLite and the Performance Implications of Indexes

Indexes make an enormous difference in the read speed of a databases. I have previously mentioned that adding proper indexes is a significant part of improving overall database performance. We can use SQLite and Python to demonstrate how much of … Continue reading

Read more

0 comments, 308 reads

Posted in SQLWise on 5 February 2017

Monitoring SLAs with SQL Monitor Reporting

Proactive Reporting for SQL Server

If you’re a return reader of this blog you know I write often about monitoring and performance of Availability Groups. I’m a very big proponent of using monitoring techniques to ensure you’re meeting your service level agreements in terms of recovery time objective and recovery… Read more

0 comments, 1,320 reads

Posted in Anthony Nocentino's Blog on 4 February 2017

SQL Server on Linux

Yes that is true, now SQL Server is on Linux. https://www.microsoft.com/en-in/sql-server/sql-server-vnext-including-Linux Download the public preview https://docs.microsoft.com/en-us/sql/linux/ I am learning it and would love to write more blogs soon.    

Read more

0 comments, 174 reads

Posted in Vinay Thakur on 4 February 2017

Get Your SQL Server Product Key with Powershell #dbatools

There are lots of tasks that are easily accomplished with bot h PowerShell and T-SQL.

Get-SqlServerKey is a command that will find your product keys. It’s not often you might need this, but it’s a pain to track them down from the registry and be sure you get them for… Read more

4 comments, 272 reads

Posted in The Voice of the DBA on 3 February 2017

How the SQL Agent Job schedule_uid broke my heart, and my jobs!

This is something that has caused me some grief in my life as a DBA. I hesitate to call it a bug, but this little gottcha resurfaced in a change that was submitted by a teammate just today. So I wanted to share while it was fresh in my mind. Read more

10 comments, 1,384 reads

Posted in cjsommer.com on 3 February 2017

Power BI Custom Visuals Class (Module 36 – Box and Whiskers (Brad))

In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual.  This is the second of two Box and Whiskers visuals that we have covered (You can learn more about the first one here). The Box and Whiskers chart is used to… Read more

0 comments, 777 reads

Posted in Devin Knight on 3 February 2017

The High Availability Conversation Part 1: Introduction

Hello Dear Reader!  Twitter is a fantastic tool if you use SQL Server.  It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some of the best technical forum conversation on the subject.  I was on Twitter and my friend Kenneth Fisher asked a question.…

Read more

1 comments, 1,220 reads

Posted in SQLBalls on 3 February 2017

Newer posts

Older posts