Latest Blog Posts
In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that comes with SSIS to build a Package that sourced data from a flat file and loaded it into a Table in a SQL Server Database.
I also mentioned another… Read more
Theoretical versus real-world
There is not a strong need for developers to know the theoretical definition of 1st thru 5th normal form, but there needs to be an understanding of some design practices. The keys are:
- No Duplicate data in columns in one table
- Relationships built as…
The last twelve months in my certification world have been rather odd. First, Microsoft has terminated their Microsoft Certified SQL Server Master program, which caused a large uproar in the community. Enough has been said on this subject…
Next, since the SQL Server platform is going through more frequent… Read more
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