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

Archives: January 2017

SQL and the other technologies

I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow.

2013 2014 2015 2016
JavaScript 56.6% 58.9% 54.4% 85.3%
SQL 59.6% 57.1% 48.0% 58.9%
C# 44.7% 37.6% 31.6% 35.3%
Java 42.5% 37.6% 31.6% 35.3%
PHP 34.8%…
Read more

0 comments, 509 reads

Posted in Si vis pacem, para sql on 31 January 2017

Disabling #sqlprompt Formatting

I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want code reformatted. One great example is when I write INSERT statements. Here’s what I might write:

INSERT dbo.Payments_A
  ( [Month], SerialNumber, DateBegin, DateEnd, paid)
  ( 'Mar-15', '0000000000001', '3/16/2015 0:00',…

Read more

0 comments, 823 reads

Posted in The Voice of the DBA on 31 January 2017

Pesky Percent File Growth

As DBAs we all know setting your file growth to grow by percent is not optimal.  It can cause all kinds of issues, which rear their ugly heads as performance problems (see these articles by Brent Ozar, & Tim Ford).  So, when I have to support… Read more

1 comments, 674 reads

Posted in SQL Swimmer on 31 January 2017

Hiring Productive Employees – #TAPtips

Starting a business is easy. Have an idea, some skills, a customer or two, and you are in business. However, growing a business is tough. One thing you’ll learn, is to grow a business, you have to build a team. Hiring productive employees or team members will be a core… Read more

0 comments, 605 reads

Posted in Marc Beacom on 31 January 2017

My First SQL Saturday – As A Speaker!

I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.

I will be presenting my What is Power BI? session.  There have been a ton of changes to Power BI since I last presented this, so I’m off to start… Read more

0 comments, 581 reads

Posted in SQL Swimmer on 31 January 2017

A Letter To A Younger Yates

Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a few minutes so we can talk and maybe help another data professional that is just starting out on his or her journey. Nah, it won’t take us a long time… Read more

1 comments, 659 reads

Posted in The SQL Professor on 31 January 2017

Join webinar on SQL Server 2016 Always on

Click [HERE} to Join webinar.

SQL Server 2016 - AlwaysOn

An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one to eight sets of corresponding secondary databases.…

Read more

0 comments, 514 reads

Posted in Ganapathi's MSSQLLover on 31 January 2017

SQL Server 2008 RTM - Maintenance Plans need Integration Services installed

The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not go into here I have been building some SQL Server 2008 instances. This is because of a large SQL Server migration project that I’m working on for a client. The…

Read more

2 comments, 824 reads

Posted in The SQL DBA in the UK on 31 January 2017

Speaking at Techorama 2017

I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but not limited to) Microsoft technologies. This year, the event is even bigger as they have merged with the IT Pro event ITPROceed (where I have spoken 3 times in… Read more

0 comments, 648 reads

Posted in Koen Verbeeck on 31 January 2017

Another 5 Power BI Tips

If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about Power BI. Part of the reason I blog so often about Power BI is because that’s the topic of a whole bunch of conversations I’m having with my customers.… Read more

4 comments, 976 reads

Posted in SQL with Dustin Ryan on 31 January 2017

Parse Dynamics AX Context Info

Dynamics AX and SQL Server

More and more I am seeing clients requiring assistance with the Microsoft Dynamics Suite. Each of the products in the suite comes with a different set of performance issues and gotchas. In this article I will only be discussing the AX product and an easy… Read more

3 comments, 1,102 reads

Posted in SQL RNNR on 30 January 2017

A New Year, A New Company and A New DenverSQL Chapter

2016 was a great year, both personally and professionally. Personally, our family is well and the kids are growing into their personalities. Professional, DawaBI merged with Quanta Intelligence to form Datalere. Our intent with Datalere is to grow and be proactive in earning new customers. In the past, both Carlos… Read more

0 comments, 600 reads

Posted in Marc Beacom on 30 January 2017

#ReadyRoll at #SQLintheCity

When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source Control and DLM Automation work really well to bundle up changes in a VCS and easily deploy them.

However, as I worked with Daniel Nolan, the creator, and learned… Read more

0 comments, 751 reads

Posted in The Voice of the DBA on 30 January 2017

Warning: Not a valid checkpoint file name

One of the other DBAs I work with noticed a warning message that was flooding the log files on one of our servers. He asked me to look into it. I did a Bing search for the warning message and found no useful links. This is the warning message: [WARNING]…

Read more

Azure quick start

In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well here’s another one.

Throughout the Azure portal you will find buttons called Quick Start. You won’t find it everywhere but I’ve found it in the Resource… Read more

1 comments, 622 reads

Posted in SQLStudies on 30 January 2017

Altering Data Length of a Primary Key Column

This is not an article or a script. I am posting this just to share my experience and I feel it can save a lot of time in a specific situation. Problem – We have a table let’s say Customer and this table has an alpha numeric primary key CustomerID…

Read more

0 comments, 827 reads

Posted in Help on SQL Server on 30 January 2017

Monday Coffee 2017-01-30

Wow, what a week last week was.

The biggest thing that happened was that I got a session at SQL Saturday Iceland! They had loads of submissions and could only pick around 20 so very chuffed to have been one of those selected, cue smug face.

The event is… Read more

0 comments, 535 reads

Posted in The DBA Who Came In From The Cold on 30 January 2017

Enabling Remote Access to the Dedicated Admin Connection

Recently I was running a health check on one of my clients SQL Servers and I noticed that access to the dedicated admin account was disabled. They would not be able to connect to the Dedicated Admin Account (DAC) remotely.  It is generally good practice to enable remote admin connections.…

Read more

0 comments, 1,269 reads

Posted in The SQL DBA in the UK on 30 January 2017

How to compare two SSAS databases with a custom MDX query

[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare two similar SSAS databases located in different environments. So I quickly ran an MDX query with some key metrics against each of the SSAS databases and presented the results…

Read more

1 comments, 1,386 reads

Posted in Data Adventures on 29 January 2017

Worth Reading – Something I learned while unemployed by Rod Falanga

SQLServerCentral recently published Something I learned while unemployed. Written by Rod Falanga, it has lessons worth learning about making time to stay current and the difference between knowing concepts and implementing them.


Read more

0 comments, 802 reads

Posted in SQLAndy on 28 January 2017

Older posts