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

Latest Blog Posts

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, 124 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, 160 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, 110 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, 200 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, 250 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, 205 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

0 comments, 232 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, 319 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

3 comments, 280 reads

Posted in James Serra's Blog on 11 October 2017

Database Fundamentals #13: Data Entry Through T-SQL

T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t be typing everything into T-SQL directly as we’ll do here. You’ll be able to use stored procedures and parameters to automate the use of scripts. These will also be generated… Read more

2 comments, 155 reads

Posted in The Scary DBA on 11 October 2017

Azure SQL Database Level Firewall Rules

I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog post. If you can’t remember the section on firewalls then I will bring the following diagram to your attention.

The main purpose of this post today is to discuss… Read more

1 comments, 144 reads

Posted in All About SQL on 11 October 2017

sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)

I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into a schemaname and objectname and vise versa. To do that you’ve either used the functions OBJECT_ID, OBJECT_SCHEMA_NAME, and OBJECT_NAME or sys.objects and sys.schemas.

So what’s the difference?… Read more

1 comments, 131 reads

Posted in SQLStudies on 11 October 2017

Why I Go to Summit Each Year?

This year will be my 6th PASS Summit that I will have attended. Some people have asked me why I still go, and what I get out of Summit that I don’t get from attending and speaking at SQL Saturdays. That’s an easy one for me to answer,… Read more

0 comments, 128 reads

Posted in SQLEspresso on 11 October 2017

Identity_Cache feature introduced in SQL Server 2017

Hello friends, Please find the full article at this link – https://social.technet.microsoft.com/wiki/contents/articles/40666.sql-server-identity-cache-feature-in-sql-server-2017.aspx   Advertisements Tagged: Identity_Cache, Sql Server, SQL Server 2017, Sql Server Developement

Read more

0 comments, 166 reads

Posted in Kapil Blogs on 11 October 2017

SQL Server Temporal Tables

Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level versioned copies of data. When using temporal data, the database does automatically what many DBAs and application developers have had to do manually for years to track point-in-time versioning for… Read more

1 comments, 151 reads

Posted in Tim Mitchell on 11 October 2017

Avoid “Constants” in T-SQL

Unlike some other languages, T-SQL doesn’t have the concept of a constant.

As good coders, we’ve all at some point tried to use a SQL variable to hold a constant value within a stored procedure, in order to make our code both more readable and maintainable.

I’ll give you an… Read more

0 comments, 201 reads

Posted in Matthew McGiffen DBA on 10 October 2017

Kill a Connection, Session, or Command in Analysis Services

One of the useful features of the SSAS Activity Monitor is the ability to cancel sessions and queries. Though there is no obvious way to do this through SSMS you can in fact write an xmla query to kill either the session, connection or command:

View the code on Gist Read more

0 comments, 126 reads

Posted in Richie Lee's SQL Stuff on 10 October 2017

Microsoft Ignite US 2017 – Major Azure Announcements

Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major announcements across the entire solutions portfolio suiteand this year 2017 was certainly no exception to that!

This year it was held in Orlando, FL over 5 days (25 – 29 Sep) and… Read more

0 comments, 235 reads

Posted in Mr. Fox SQL on 9 October 2017

Using xp_delete_file

First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions, so you’d be better served by using Powershell or some other type of scripting mechanism. This procedure is not supposed to be supported in the future, so I’d remove this… Read more

2 comments, 228 reads

Posted in The Voice of the DBA on 9 October 2017

Newer posts

Older posts