Archives: May 2014
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields related to auditing as it stands in SQL Server.
In talking to the person who raised the valid concern about the… Read more
“This is one reason I’ve been hesitant to remain current with Cumulative Updates (CUs). Microsoft doesn’t stand behind them, with the text on each CU page that users should only apply the patch if they…
I’m back at MagicPASS tonight, delivering two presentations – one about credit card security using SQL Server and one about learning plans, both are topics I’m enthusiastic about. It’s a great venue, if you’re in the area hope you can make it.
Late last month, I delivered a webcast for Pragmatic Works Training on the T’s. The session was titled Getting Started with Windows Azure and SQL Databases. In the session, I how data platform professionals can start looking at Microsoft Azure and some of the services and their benefits… Read more
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more
Similar the post earlier today, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month. This was is titled Leveraging Cloud for the Modern SQL Developer. In the session, I discussed how and where SQL developers can look to Microsoft Azure… Read more
Quick notes today:
- Event team likes first flyer (retro) better than the second one (doesn’t have enough why, doesn’t use space well). Both can be tweaked. I’m going to order two more. One to try to get a yet different take on the event, one to trial a seminar flyer…
Eleven candidates for the nomcom this year, details at http://www.sqlpass.org/Elections.aspx. The NomCom campaign will open on June 2 and close on June 6, 2014. Balloting will open on June 3 and close on June 6, 2014. Which does make it a little strange – the names are public, but… Read more
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect because the maximum number of ’1′ dedicated administrator connections already exists. Before a new connection can be made, the existing dedicated administrator connection must be dropped, either by…
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)?
Great question! Not one that is straightforward to answer via the Twitter medium though, so I wanted to share some more detail here. Read more
Note: Posted May 27, 2014, additions posted May 28, 2014 further down.
I think it’s been discussed a time or two, but the idea of issuing certificates of completion for SQLSaturday came up as an idea on how to increase value/attendance at SQLSaturday Orlando this year. The basic idea is… Read more
Similar to yesterday’s post, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month. This was is titled 5 SQL Server Indexing Myths. In the session, I discussed discussed five common indexing myths that I’ve come across over the years. The… Read more
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the first time I thought that Powershell might prove more useful than other methods. This series looks at my script, and this part examines the first part that I wrote.
I… Read more
Here is the second of the two flyers I ordered from fiverr.com (see the first one here). The center image is from the event site and is of our venue, Seminole State College. It’s clean, but I think the images don’t add a lot of value. Appreciate any feedback… Read more
Get User In Reporting Services is my newest question to be published at SQLServerCentral.com as a “Question of the Day”. Interestingly so far 71% of people are getting one of the three correct answers, but 84% are also picking the same wrong answer. Can you figure it out?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)
Languages of Big Data
Big Data is here and rapidly growing. If you are just starting to learn about Big Data then it is important for you to understand all of the various pieces that can be used in Big Data architectures. The Apache foundation is a major player in… Read more