Latest Blog Posts
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes today and even though I haven’t been able to take part in all of them, I have thoroughly enjoyed working through these challenges.
DBAs don’t often get… Read more
While trying to restore SQL Server database or do any other actions which require exclusive database access you may face with the following error:
Exclusive access could not be obtained because the database is in use.
Here is a quick solution which is much handier than killing all connections manually… Read more
A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had to give them a shot and while I was somewhat disapointed in my scores on a few over all they were a lot of fun.… Read more
We have a solid tradition here in Orlando of offering some all day classes the Thursday and Friday before SQLSaturday. It started way back at #1 when we brought Joe Celko to town! It’s a way to give our local community the chance to do some deeper learning at a… Read more
What is SQL Server Polybase?
Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage. This technology will allow you to continue to leverage SQL Server for your data warehousing and access data stored in different formats… Read more
I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG). This session resulted from feedback we received in the user group on differences between database developers and BI developers. If you are interested in seeing the presentation content it is uploaded here: Read more
When, I first saw this statement a Hindi proverb come to my mind which is “1 teer 2 nishane” . The meaning of this proverb means a single bow which hit two different aim in one shot.
So let me explain “Merge” statement in more detail. With the help of… Read more
There’s a place in the SQL Server hell where you can find poor souls wandering the paths of their circle, shouting nonsense table names or system-generated constraint names, trying to baptize everything they find on their way in a different manner. They might seem innocuous at a first glance, but… Read more
In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a SQL Server database and just keeps retrying until it is available:
If you have a CI build and…
A few weeks ago, for TSQL Tuesday, I wrote about how I used Powershell to manage failing over clusters. At work, we have now implemented that script in our patching process and it has reduced our patching time significantly. However, the process was still missing something. A validation… Read more
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on continuing. You can read (in full) about previous whistle stops and why they are called whistle stops here.
Amazing this… Read more
Sooner or later every DBA needs to purge old data from database tables. And it often happens that such tables are large enough. This can be done using table partitioning. Such approach is used rarely but in case of really large table it is very useful. In this article we`ll… Read more
Speaking next Wednesday July 22nd, at Vermont SQL PASS group, thanks to Roman Rehak? for the invite!
I'll be doing an update to Database Security Best Practices for the Vigilant DBA and Developer, with a look at SQL 2016 CTP2.1 Always Encrypted option.
UPDATE, post meeting download available now (improved link too):…
A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement Table-Valued Functions (MSTVF). Since then, whenever I speak about ITVFs / MSTVFs, I’m frequently asked about how Scalar Functions (SF) perform. My stock answer has always been that they perform… Read more
Posted last week, Is the Golden Age of Information Technology Almost Over? generated some interesting comments. It’s tough to write about potential changes without saying the sky is following, but it does make a good opinion piece!
I was discussing it with Steve Jones after it was published and he… Read more
(Originally appearing at ForITPros.com).
I was recently chatting with a friend who was seeking advice about difficulties in their job. This was a job which, a year ago, she described as her dream job. It quickly became evident to her that it was actually a nightmare job. The company,… Read more