Latest Blog Posts
I earned my MCSE: Business Intelligence Certification on May 27, 2015. It was a long road, but I did it. Back in May of 2013, I wrote about being Certifiable and wasn’t really interested in pursuing any certifications. What made me change my mind you ask? The short answer is,… Read more
Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong. I would surmise that, in most cases, installing the service pack is a non-event. No flashing lights, no fireworks, no applause and no major hiccups. This post is not about one of… Read more
With the CTP2 of SQL Server 2016 now released you may be eager to try it out. One of the best ways to do this in my opinion is to set it up on a virtual machine. You could certainly do this with VMWare or Hyper-V but my new preference… Read more
So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the new features inside SQL Server 2016. You can download SQL Server 2016 CTP2 here: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016
While I was playing around with all the new features inside SQL Server 2016 (especially… Read more
A question came up at work the other day, mostly as a mind game, but you never know it might actually come up at some point. So here is the idea.
- UserA is a member of Group1, Group2 and Group3.
- Group1 is set up as a server principal with a…
By David Postlethwaite
On the Database Scale page we can decide on the performance level that we want our database to have.
There are three performance levels Basic, Standard and Premium
- Basic is best suited for a small size database, supporting one single operation at a time such as for…
For those who haven’t noticed already:
SQL Server 2016 CTP2 (or Preview as some call it) has just been released!
This means it is play time!
You can either download a copy if you’re old school like me, or you can spin up a VM in Azure like all the… Read more
The Importance of Log Files in SQL Server
On the SQL server every day we perform many transactions and as we know that all these transactions affect the log file. After all, the transactions are stored in the log file so every transaction contains some space in the log file… Read more
By Steve Bolton
…………The same rules that applied to my amateur mistutorial series on A Rickety Stairway to SQL Server Data Mining and Outlier Detection with SQL Server are in play for this series of occasional articles, which will provide a brief overview of using various third-party data mining… Read more
I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem I’ve had a few times. Getting time slots inside of a period that I want to query. If you have a similar need, or want to learn more, I’d urge… Read more
Massive parallel processing (MPP) is the future for data warehousing.
So what is MPP? SQL Server is a Symmetric Multiprocessing (SMP) solution, which essentially means it uses one server. MPP provides scalability and query performance by running independent servers in parallel. That is the quick definition. For more… Read more
I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international laws regarding SPAM. This has been something of an education, so anything I say wrong below, it’s because I’m wrong, but not malevolent (at least in regards to this… Read more
What exactly does this mean? We’ve heard of “code patterns” in other programming languages, but what does it mean to use T-SQL code patterns to develop high performance T-SQL? Having now been called out by a couple of folks in the SQLverse that I respect, most recently the editor of… Read more
This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT professional. The conference takes place the 11th of June at Utopolis Mechelen. My session is situated in the Data Platform & Internet of Things track and is titled Demystifying… Read more
I usually don’t post small things like this, but today I fought with this obnoxious problem long enough to convince me that it deserved a shout out to the community.
When you create an alias in the SQL Server Configuration Manager, make sure that the alias name contains no spaces,… Read more