-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

DevOps Basics–Git Clients

This is also a part of a basic series on git and how to use it.

There are lots of git clients. If you look at the top list for this year, you’ll see quite a few. I’ve used a couple of these, but they all give you roughly… Read more

2 comments, 1,369 reads

Posted in The Voice of the DBA on 7 September 2017

There EXISTS a place where SELECT 1/0 doesn’t return an error.

Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical joins (Q7)

Using AdventureWorks2014

SELECT *
FROM Sales.SalesOrderHeader as head
WHERE EXISTS (
	SELECT 1/0 as y
	FROM Sales.SalesOrderDetail AS det
	WHERE det.SalesOrderID = head.SalesOrderID);

At… Read more

3 comments, 219 reads

Posted in SQLStudies on 7 September 2017

“Invalid class [0x80041010]” error when trying to access SQLServer’s WMI classes

I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have on a bunch of hosts so I could confirm if they are in “running” state.

— Quick note —
For those who don’t know, dbatools is… Read more

1 comments, 249 reads

Posted in Cláudio Silva on 7 September 2017

Q&A Session with SQL Server on VMware Experts at VMworld EMEA

Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask great questions, I thought I’d extend an offer to everyone at the European show coming up in a week! Let’s talk SQL Server! We are going to crash the… Read more

0 comments, 131 reads

Posted in Technobabble by Klee from @kleegeek on 7 September 2017

SQL Server: SARGability part 2

In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post continues the series and today we’re going to discuss the dangers of functions.

Recently, I’ve seen several customers that have been placing functions around columns in the WHERE clause.… Read more

1 comments, 1,380 reads

Posted in Confessions of a Microsoft Addict on 7 September 2017

Attend “T-SQL’s Hidden Support Feature” online September 11!

I’m presenting T-SQL’s Hidden Support Feature for the DBA Fundamentals virtual chapter on Monday, Sep 11 at 9:30 PM CDT! Session description: The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database… Read more

0 comments, 142 reads

Posted in SQL Awesomesauce on 6 September 2017

Oracle-SQL Datatype conversion issues through linked server

Msg 9803, Level 16, State 1, Line 1 Invalid data for type"numeric".

Fix: Use TO_CHAR function. See below example

SELECT * FROM OPENQUERY(NHRTEST,'SELECT PRIMARY_ID,
ORGANIZATION,
SUB_LINE_STATUS_CODE,
ORGANIZATION_ID,
CONTRACT_NUMBER,
CONTRACT_ID,
RENEWAL_MODIFIER,
CACT_STATUS,
START_DATE,
END_DATE,
CREATION_DATE,
LAST_UPDATE_DATE,
DATE_APPROVED,
DATE_SIGNED,
ORG_ID,
SHORT_DESCRIPTION,
CURRENCY_CODE,
CONVERSION_RATE,

Read more

0 comments, 170 reads

Posted in SQL Articles by Nani on 6 September 2017

SQL Server on VMware VMworld USA Videos Now On YouTube

I just realized that our two SQL Server on VMware sessions that I co-presented on Tuesday at VMworld USA, both of which made the top 10 sessions of the day list at the conference, are now on YouTube! They are free to watch for everyone!

For those of you… Read more

0 comments, 997 reads

Posted in Technobabble by Klee from @kleegeek on 6 September 2017

Connect Windows 10 client to a VPN on Windows Server 2012 R2

I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows, was unable to connect to our VPN (Virtual Private Network). We use the built-in VPN on Windows Server 2012 R2, which makes it extremely convenient to manage per-user security without… Read more

0 comments, 140 reads

Posted in Born SQL with Randolph West on 6 September 2017

Toolbox - IO, IO, Why are You So Slow?

This is the next in a series of blogs I am going to create talking about useful tools (mostly scripts) that I use frequently in my day-to-day life as a production DBA.  I work as a Work-From-Home DBA for a Remote DBA company, but 90+% of my job functions are…

Read more

2 comments, 1,710 reads

Posted in Nebraska SQL from @DBA_ANDY on 6 September 2017

Database Fundamentals #9: Schemas As Containers

Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas provide you with another tool to control how your database behaves.

Schemas

The tables created so far in this blog series have all been attached to a schema, dbo. Depending… Read more

0 comments, 1,758 reads

Posted in The Scary DBA on 6 September 2017

CALCULATE and FILTER: A Love Story?

There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going to repeat all that information here. Noteworthy resources (by “the Italians” of course):

In this… Read more

5 comments, 1,548 reads

Posted in Koen Verbeeck on 6 September 2017

Please Don’t Do This!

Please, please, please Admins do not leave your default index fill factor at 0. This means you are telling SQL Server to fill the page 100% full when creating indexes. This also means you are forcing it to a new page when additional inserts are done. These are called PAGE… Read more

10 comments, 3,201 reads

Posted in SQLEspresso on 6 September 2017

Dynamic Threshold for Statistic Update - SQL Server 2016

By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statistics setting is turned on by default, the threshold for number of changes to trigger auto statistic update before SQL Server 2016 was

For tables with more than…

Read more

0 comments, 1,081 reads

Posted in SQL and SQL Only on 6 September 2017

Exploring the Kubernetes dashboard in Azure Container Services

Last week I went through how to run SQL Server in Kubernetes on Azure Container Services (ACS)

This week I want to explore the built-in Kubernetes dashboard which is available in ACS by default. (N.B. – You will need to have run through the steps in my last post to… Read more

0 comments, 177 reads

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

TSQL2sday #94 Lets get all Posh!

Write-Output "What are you going to automate today?"

 

Welcome to T-SQL Tuesday for September 2017!

T-SQL Tuesday is a chance for you to join in the SQL Server community and write a blog post on a suggested topic. It makes for a great way to find a bunch of… Read more

72 comments, 151 reads

Posted in SQL DBA With A Beard on 5 September 2017

Game Night is Back at the Summit

Last year Andy Warren and I worked out a deal with the PASS organization to sponsor a game night on Thursday evening since there were no official events. The event went well, with way more attendance than we expected. I was actually amazed at the number of people that… Read more

0 comments, 537 reads

Posted in The Voice of the DBA on 5 September 2017

Power BI Custom Visuals Class (Module 67 – Impact Bubble Chart)

In this module you will learn how to use the Impact Bubble Chart Custom Visual.  The Impact Bubble Chart is an animated bubble chart that allows you to compare two entities against each other.

Module 67 – Impact Bubble Chart

Downloads

Read more

1 comments, 1,598 reads

Posted in Devin Knight on 5 September 2017

Luck and the PASS Summit

I recently read an article asking the question whether or not we downplay the role that luck plays in our lives and I immediately thought of the PASS Summit.

Obscenely Lucky

I am, quite frankly, embarrassingly, obscenely, stupidly lucky.

I just am.

I married WAY over my head. I stumbled… Read more

5 comments, 128 reads

Posted in The Scary DBA on 5 September 2017

SQL Homework – September 2017 – Create a home lab

As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something important at the start. It’s pointless to ask someone to create a table when they don’t have someplace to do it.

There is no need to go as far as… Read more

0 comments, 149 reads

Posted in SQLStudies on 5 September 2017

Newer posts

Older posts