Latest Blog Posts
I had a brief conversation with Stuart Ainsworth yesterday over Facebook. In passing I mentioned that I was doing well managing blood sugar levels and he indicated he didn’t know I had been dealing with anything like that. It reminded me that I hadn’t said anything about being diagnosed with… Read more
VS Live takes place in Austin on May 15-18, 2017. This is a great conference in a fun city. It’s a full stack event, with the change to learn about cloud computing, ALM/DevOps, SQL, and Visual Studio, all at the same event. You can move from room to room and… Read more
Nearly May! Although it’s been snowing this week in Dublin so summer still appears to be a while off…
Community driven Enhancements in SQL Server 2017
The MS Tiger Team list the new features in SQL 2017 that have been built based on feedback from the community
I have been quite interested by vs code and have been using it more and more recently. I use it for all my GO (#golang FTW) work and also powershell and I have been toying with the sql tools team's sql extension which is great. For a long time I…
Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a wide variety of indexes; but, today we’re going classic and talking about Non-clustered indexes.
Microsoft has a lot of great resources discussing these topics, though I thought I’d take a… Read more
On May 18, 2017, I’ll be giving a talk at the Syntax Code and Craft Conference in Charleston, SC. If you haven’t heard of this conference, it’s a 2-day affair primarily focused on developers. Here is my talk:
MAKE SQL SERVER GO FASTER
An app is a failure if… Read more
At SQLskills, we just launched our new training class on Azure that I will be teaching in Chicago, and my course on Azure SQL Database was just published on Pluralsight too! While I am sharing awesome news, we also launched our new 3 day training class on upgrading SQL Server Read more
Another installment of 24 Hours of PASS is coming up next week on May 3-4! This semiannual event features 24 back-to-back webinars on a certain theme. The theme this time is data security and data quality, a subject I’m passionate about.
I’m happy to say that I get to present… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
I was chatting with someone the other day about MAX() and how it can work within a set of rows, rather than across an entire result set. That’s… Read more
Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run into something like this I am going to write a quick blog about it. It’s something new I’m trying
While recently examining an existing SSIS package before implementing some needed… Read more
Mit einigem Wehmut darf ich verkünden, dass ich das Amt des Regionalgruppenvertreters (RGV) der PASS Regionalgruppe Rheinland niedergelegt habe. Seit Januar 2011 bin ich RGV gewesen – also für ziemlich genau 6 Jahre.
- Für die Noch-Nicht-PASS’ler die kurze Anmerkung: Die PASS Deutschland (e.V. um genau zu sein) ist ein…
0 comments, 86 reads
Posted in Andreas Wolter SQL Server & BI blog (English / German) on 27 April 2017
On May 2, 2017, I’ll be giving two talks at the SSWUG 2017 Virtual Conference. Here are the talks:
Building a Home Grown Auditing Infrastructure for SQL Server
Not everyone has the budget for 3rd party tools to provide audit / security information on their SQL Server environment.… Read more
You could win an Amazon Echo from Redgate. Our contest is still open for a few days, so post a comment on my blog and take your chances. I’ll be picking from the comments next week.
Filed under: Blog Tagged: Redgate, SQL Clone, syndicated
I was chatting on the SQL Community Slack with my friend Sander Stad b | t about some functions he is writing for the amazing PowerShell SQL Server Community module dbatools. He was asking my opinion as to how to enable user choice or options for Agent Schedules and… Read more
Sometimes we, as data professionals, have to think outside the box. I know, crazy idea right? Each shop and situation are different; there will always be several different ways in most cases that you can arrive at a solid solution.
This post has a few intentions behind it:
Cue Princess Jasmine.
What do I mean “Cue Princess Jasmine”?
Well because starting today, it’s a “Whole New World for You & Me”
What on Earth am I talking about??
The SqlServer PowerShell is now available for download in the PowerShell Gallery! http://sqlps.io/sqlserver
What Does It Mean!?
It means that… Read more
I had this question come up at work the other day and while I knew it was true I wasn’t as sure about why as I’d like. The person I was working with wanted a real answer, not just Because I say so, so off to the internet I… Read more
Last week Microsoft confirmed that the name of SQL vNext will indeed be SQL Server 2017. I was looking through the documentation for more info on Adaptive Query Processing as I wanted to write a post on adaptive joins but then I saw: –
To see the new Adaptive Join… Read more