Latest Blog Posts
When you’ve got a SIEM appliance or application, you want actions and events going into it as a central repository. That allows you to see patterns and hopefully track incidents across systems. As a result, if you want to track actions in VMware’s vCenter and you’ve got the database hosted… Read more
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this… Read more
This never gets easier. I was able to attend a bunch of sessions in the last month from a number of speakers that I’d never seen before. A lot of them were good, very good. In fact, I’d go so far as to say I think the general level of… 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
- Dell Webinar: 10 Ways To Abuse T-SQL
- Don’t Get Slimed By Bad Parameter Sniffing
- Winning From Within: a…
Today, I received an email from the developer asking if there is a better way instead of the COUNT (*) Transact-SQL statement, to count the number of records in a table. My reply to his question is yes, there are several methods to get this information from SQL Server. However,… Read more
This is part of a series where I set up a virtual lab for testing and misc. work. The other parts in the series are here: Building a Virtual Lab with Hyper-V.
Once I had the machine up and running, I knew I needed to get the networking setup.… Read more
The weakest link in database security is the same as for most all IT security: people.
Because the weakest link is always people, we have adopted a principle called The Principle of Least Privilege to determine how we should assign security. If you’ve never heard of it, it’s a basic… Read more
In one of SQL Server Central’s recent daily newsletters, Steve Jones’s editorial was inquiring whether or not anyone has been using the CLR (common language runtime) integration within SQL Server. Recently, a change in a business process dictated that we needed to delete over 3 billion rows from a 16… Read more
Tonight I was lucky enough to be able to present to my home SQL Server Users Group in Omaha, Nebraska. I gave my presentation ‘Squeezing Top Performance from your Virtualized SQL Servers’ to a packed house. I thoroughly enjoyed the session, and hope you did too!
To… Read more
Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.
The issue is that using… Read more
The simple query to find the database backup status
The select statment consists of
The query will only run from sql 2005 and later version.
Select SERVERPROPERTY('ServerName'), db.name, CONVERT(VARCHAR(10), b.backup_start_date, 103) + + convert(VARCHAR(8), b.backup_start_date, 14) backup_start_date, CONVERT(VARCHAR(10), b.backup_finish_date, 103) + +…
Number 8! Our eight annual SQLSaturday in Orlando is coming up on September 27th (note, it’s technically our tenth, but my friend Kendal Van Dyke says that #3 & #4 – the ‘tweener’ weekend – shouldn’t count!). Either way, I’m excited that it’s time to start the planning and… Read more
You can put pretty much any character you want into an object or schema name by enclosing the name in ‘s. This does not however mean that you should. There are two specific cases that I’ve seen that are in general a bad idea.
I’ve seen names that actually have… Read more
SQL Server Data Encryption Types
Businesses today have a greater need than ever to protect their data from security breaches. Data stored in databases are a prime target for hackers since it contains data that is normalized and contained in a central location. Once a hacker accesses a database all… Read more
Those of you who use SQL Server Analysis Services (SSAS) are likely familiar with the “bible” for designing cubes: Expert Cube Development with Microsoft SQL Server 2008 Analysis Services by Marco Russo, Alberto Ferrari , and Chris Webb. Well, a new edition has just been published, with a changed name… Read more
I often do my SharePoint setups on virtual machines since I need to build them up and tear them down frequently. Hyper-V is a beauty when it comes to demo environments. A few weeks ago I was doing an install and got an error that was absolutely no help.
Let’s throw out all the reasons why you need to do the…
My company cut the training budget this year, and it’s not that uncommon for that to happen anymore. However, I’m still getting my week of training in, and more, without paying much.
Blogs of people who talk too much – FREE
There’s so much for free online, but you’re reading… Read more