Latest Blog Posts
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database, system tables/views/procedures and so on.
SQL Server Management Studio provides an option to hide these objects from Object Explorer to prevent *accidental* use.
To enable this option follow below steps. Read more
The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML. In a previous blog I showed how to use a web service task to get the city and state when entering a zip code.
The results we got back from…
So, here’s a silly little take on a serious end-user issue where no-one could access the production database.
Got a call from a client recently. Like something out of a LifeAlert® commercial: “Help! I'm stuck in single user mode and can't get out! “
I figured this… Read more
A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time, my friend, colleague and fellow contributor to this blog, David Postlethwaite was making his full speaking debut delivering a session entitle “Real DBAs Don’t need a GUI” it was a… Read more
As once a data architect, I cannot help but admiring and appreciating the data model behind the sql server job schedules. The core design is actually just one table, msdb.dbo.sysschedules, but the design beauty/elegance of the table is that it can support many different types of schedule with a rich… Read more
What is a SQL Server Filtered Index
A SQL Server Filtered index is a nonclustered indexes that can be used to increase query performance when selecting records from a table. This type of index can be especially useful when there are a small count of distinct values in a column… Read more
Neue “Erweiterte Ereignisse” (XEvents) für Tracing in SQL Server 2014
Zunächst gibt es 3 neue Pakete („Packages“), die alle zu der neuen Arbeitsspeicher(„In-Memory“) -OLTP Engine: XTP, aufgeteilt…
0 comments, 141 reads
Posted in Andreas Wolter SQL Server & BI blog (English / German) on 4 April 2014
I writing this blog post as a result of the following two questions, which I’ve been asked by one of my blog follower recently.
- Question#1: Does it matter who is the owner of the SQL Server Agent job?
- Question#2: Is there a way to quickly update the job owner for…
In deference to my British employers, I’ll use their word.
It constantly strikes me how rude, stupid, and unfriendly people can be on the Internet. I’ve been trying to avoid even reading comments on many places, including Facebook because I’m struck by how people behave. I haven’t completely succeeded and… Read more
I don’t know anyone at Spotify, nor have I worked there. However when I see descriptions and explanations like this one of how they organize and build their culture, it makes me think they’re doing it right.
Autonomy is important, and it helps motivate people. I need to do more… Read more
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting up Data Collector in SQL2014. In the walk-through if there is a new feature or change which is specific to SQL2014,then I will highlight that.
As soon… Read more
After a bit of an enforced sabbatical from blogging (short but boring story), I was interested to see how my blog had fared over the last month in essentially what was a re-launch. The list below is one of popular posts rather than a top N format due to the… Read more
My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our environment I have been watching it displace other schedulers to become the centralized scheduler. As I have learned more about the capabilities of Control-M as well as becoming more alert… Read more
I’m really enjoying picking a speaker of the month. It forces me to sit through a lot more sessions at the events I attend. I had been getting rather slack about attending sessions. It’s easy to get caught up in networking so much that you’re not taking advantage of the… Read more
This question of the day didn’t turn out well at all – required too big a leap the way it was written to get to the key answer. Four were easy, one was not. I confused the issue with a less than great trigger – not deliberately, sadly. The lesson… Read more
Maybe too serious a topic for a Friday, I wrote Team Reputation because I like working for good teams – who doesn’t? Most teams are average and that’s ok, but it’s a lot more fun to be part of the big red machine if you get the chance (and have… Read more
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.
Posts That Were Popular This Week
- The Phoenix Project: a DBA rises from the ashes
- Automated Permissions Auditing With Powershell and T-SQL: Part 1
One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This wait type is usually at the top of the list when you query the sys.dm_os_wait_stats on servers where you configured the MDOP setting to be anything but ‘1’. CXPACKET waits…