Latest Blog Posts
The 2014 PASS Summit is coming up in a few weeks and thousands of SQL Server professionals will be coming to Seattle for the event. Many will arrive early, and many will be there for the first or second time in their careers.
Upcoming conferences end of 2014: Microsoft Technical Server Summit, MVP Summit, PASS Summit, Microsoft Technical Summit
Nach der Vorstellung des SQL Server 2014 (SQL Server 2014 - Highlights in…
0 comments, 410 reads
Posted in Andreas Wolter SQL Server & BI blog (English / German) on 15 October 2014
The election results were just posted. Congratulations to James Rowland-Jones, Wendy Pastrick, and Grant Fritchey for earning seats on the PASS Board of Directors for the 2015-2016 term. This will be the second term for both James & Wendy, so both will be building on two years hard won experience… Read more
Part of the reason I have a blog is to document issues and resolutions I do not want to forget. Yesterday morning I was on two calls using Lync and the video was blank or white. I had great audio and messaging worked fine. So the only part that was… Read more
The results are in and it seems that I’ve been elected to a place on the PASS Board.
I will strive to be worthy of the position you’ve placed in my hands. I will do my best to make a difference on the board. Watch this space for… Read more
What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish I knew but I don’t. I do know that I have been on the receiving end a few times. Just shutting down the last applications when a call or a… Read more
Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.
After getting excited about the Timeline object in Excel 2013, I tried to add this cool feature of Excel 2013 and got an error – “We can’t create a Timeline… Read more
So, I've finally decided to draw a line in the sand. I've been doing some writing lately. The radio silence will soon be broken in a big and "healthy" way. In the meanwhile, I've got caught up in naming antics, and what we should really be calling them. There may… 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.
Suffice it… Read more
This post is one of the request from OP.
Download SQL Backup SP in the same database
The probelm statement 1:-
Create a backup copy of a group of stored procedures on the same database. Using TSQL I need to find all stored procedures that meet a criteria (WHERE pr.name… Read more
Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server. However, all of them have made a deep impact on my life. I am where I am today because of these nine.
1. James Tiberius Kirk
I start my… Read more
Last week I spent some time after my presentation to Space Coast SQL talking to Kathleen Branch, the chapter leader, about what works and doesn’t work, and whether she was succeeding or not. We don’t seem to talk about that much publicly. When I was on the PASS Board we… Read more
It’s October, and another busy fall is underway for me. It’s also the second Tuesday, so it’s T-SQL Tuesday time again. The invite this month is from Tracy Mckibben, and it’s a neat topic. Not really a technical one, but a fun one that I like.
I have to admit this isn’t something I think about much. I have… Read more
Databases and newborns have a lot in common. They both require constant care. They both require constant monitoring. They also may both puke on you in the middle of the night. Unlike newborns, however, you can set up automated maintenance plans for databases. If you’re starting a new gig as… Read more
SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :-
|SYNCHRONIZING||The contents of the mirror database are lagging behind the contents of the principal database. The principal server is sending log records to the mirror server, which is applying the changes…|
Ada Lovelace has been an inspiration to many. In keeping with my blog theme, let’s call her a hero. We all have our heroes, those people who…