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

Latest Blog Posts

Performing in-database predictions in SQL Server 2016 & 2017

Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and statistical analysis inside their database engine. In SQL Server 2016 Microsoft introduced the integration of the R language and in SQL Server 2017 Python was added.

Both these languages give… Read more

0 comments, 41 reads

Posted in DotNine SQL Server and more on 17 October 2017

All New Collations in SQL Server 2017 Implicitly Support Supplementary Characters

As I was testing whether or not the new “Variation Selector Sensitive” ( _VSS ) Collations in SQL Server 2017 would assist in the following question on DBA.StackExchange:

SELECT query: filter unable to distinguish between two different characters

I ran into what initially looked to be an unfortunate situation. I… Read more

1 comments, 89 reads

Posted in SQL Quantum Leap on 16 October 2017

Power BI Custom Visuals Class (Module 73 – Heat Streams)

In this module you will learn how to use the Heat Streams Custom Visual.  The Heat Streams visual allows you to visualize and compare a categorical value over time.

Module 73 – Heat Streams


Read more

1 comments, 90 reads

Posted in Devin Knight on 16 October 2017

Speaking at IT/Dev Connections 2017 – San Francisco!

I’m proud to announce that I will be delivering two sessions at IT/Dev Connections in San Francisco! This is my second year at IT/Dev Connections, real content for IT pros!

Networking Internals for the SQL Server Professional

Tuesday, 10/24/2017: 1:15 pm – 2:30 pm

Room: Contiental 7


Once data… Read more

0 comments, 110 reads

Posted in Anthony Nocentino's Blog on 16 October 2017

Database Fundamentals #14: Modifying Data Through SSMS

I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data manipulation is not the preferred mechanism. T-SQL is the right way to manipulate the data in your database. For purposes of completion though, I will show the GUI methods in… Read more

1 comments, 86 reads

Posted in The Scary DBA on 16 October 2017

Feeling Stunned

If you work in the Microsoft technology space you are probably aware of the mass of people who refresh their inboxes like a mad man on the first of the month.  It used to be on the first of every quarter but that has since changed.  I’ll admit that I… Read more

2 comments, 89 reads

Posted in John Morehouse | Sqlrus.com on 16 October 2017

SQL Server: What will REPAIR do?

So I had a corruption issue and I was thinking about running repair but I wanted to know what would potentially get deleted.

I was faced with the following message.

Table error: Object ID 1189579276, index ID 1, partition ID 72057594046578688, alloc unit ID 72057594053132288 (type In-row data). Page (1:441).… Read more

0 comments, 95 reads

Posted in All About SQL on 16 October 2017

Permissions required for developing with Temporal Tables

Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table is a combination of auditing columns (createdate) and a history table.

Quick example using code from BOL.

CREATE TABLE Department   

Read more

1 comments, 77 reads

Posted in SQLStudies on 16 October 2017

Using Backup-DbaDatabase for a Quick Backup

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

One of the core tasks of a DBA… Read more

0 comments, 128 reads

Posted in The Voice of the DBA on 16 October 2017

How to Perform and schedule SSAS Backups ?

Steps to configure schedule SSAS Cube \ OLAP database backups :-

1. For each SQL Server Analysis Services Environment. In order to create recovery strategy, we need to have backups of the metadata that describes the databases. SQL Agent jobs must be created to run backups remotely. Typically, one of… Read more

0 comments, 131 reads

Posted in MSSQLFUN on 16 October 2017

Non Profit Umbrella Org – Good Idea?

Note: Published too soon, so lots of edits from the first version. Sorry for any confusion.

I had a question from my earlier post about SQLOrlando with regards to setting up an umbrella organization, basically asking “instead of each Chapter doing all this work, why not have one org?”. Great… Read more

0 comments, 114 reads

Posted in SQLAndy on 14 October 2017

More Notes on Non Profit Status

Following up on my post about forming a non profit here in Orlando, here are some notes that might help you get through the process a little faster:

  1. In the corporate filing for the state, use the IRS recommended language: Said corporation is organized exclusively for charitable, religious, educational, and…

Read more

0 comments, 150 reads

Posted in SQLAndy on 14 October 2017

SQL Replication SubscriptionStreams setting

In this blog, we will talk about improving distribution agent throughput by modifying the profile parameter – “SubscriptionStreams”. I will be discussing a few real time scenarios where I implemented the parameter to isolate latency issue between Distributor and Subscriber.

Real Time Scenario

Let’s think about;

  • In your environment, you…

Read more

0 comments, 102 reads

Posted in SQL Geek on 14 October 2017

Your Name is Your Brand

This topic is one that has been stewing for a while and finally this week it decided to boil over.

My first thought with this post was to write a rant. Instead, I want to try and turn it on its end and try to put a different spin on… Read more

3 comments, 189 reads

Posted in SQL RNNR on 13 October 2017

Getting the Random Module in SQL Data Generator

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it, SQL Data Generator is a part of the SQL Toolbelt. Give it a try today with an evaluation today.

I have SQL Data Generator, and use it regularly… Read more

0 comments, 239 reads

Posted in The Voice of the DBA on 12 October 2017

When Things Go Wrong in Azure

Things go wrong in IT, it is no different with the cloud. When I say cloud I am thinking quite specific  such as the  underlying infrastructure that a company like Microsoft looks after for their Azure platform.

I took the below image from https://blogs.msdn.microsoft.com/psssql/2014/03/27/dont-rely-on-a-static-ip-address-for-your-sql-database/

It shows the many different layers… Read more

3 comments, 199 reads

Posted in All About SQL on 12 October 2017

New Features in SSMS 17.3

SSMS 17.3

SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention:

  • Import Flat File Wizard
  • XEvent Profiler

Import Flat File Wizard

If you’ve worked with SQL Server for very long, you have most likely needed to import flat files… Read more

2 comments, 221 reads

Posted in A Discussion of SQL Server-Related Topics on 11 October 2017

WAITFOR isn’t a function–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I needed to delay the execution of some code the other day. This was a test that was trying to simulate a few things happening, and one batch… Read more

0 comments, 295 reads

Posted in The Voice of the DBA on 11 October 2017

Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?

In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to CAST or CONVERT a datetime2 value to binary(8), I’m getting a “binary or text data would be truncated” error. This seems really weird in context with the fact that SELECT… Read more

2 comments, 200 reads

Posted in Born SQL with Randolph West on 11 October 2017

Use cases of various products for a big data cloud solution

There are a tremendous amount of Microsoft products that are cloud-based for building big data solutions.  It’s great that there are so many products to choose from, but it does lead to confusion on what are the best products to use for particular use cases and how do all the… Read more

1 comments, 267 reads

Posted in James Serra's Blog on 11 October 2017

Older posts