See below a simple script to find latest backup date time and physical location for all the Databases in a given SQL Server...
Read MoreSee below a simple script to find latest backup date time and physical location for all the Databases in a given SQL Server...
Read MoreIf you want to get a list of SQL Server databases and their basic configuration details on your current SQL server instance, you could manually open database property windows on each and every database through SSMS and note down the...
Read MoreSometime you might want to get a list of SQL Server Agent Jobs and their schedules on your current SQL server instance. You could manually open each and every Agent job through SSMS and note down the details you required,...
Read MoreSometimes SQL Database administrators want to check whether given SQL Server instance is in clustered environment. The SERVERPROPERTY() built in metadata system function can be used to identify the clustered mode. SERVERPROPERTY() function with IsClustered Property will return “0” for...
Read More
I had the challenge of putting together a T-SQL statement that's going to be used in a few stored procedures. The stored procedures will build data based on what todays date is, if today is greater than second Tuesday of...
Read More
Here's a little video on installing the AdventureWorks 2012 & Chinook databases, we're going to be using them in future videos. The video is intended for new SQL Developers or DBA's that haven't had much experience in installing databases before.
I mentioned it a few posts ago and now its finally happened! We've recorded our first YouTube video and it's a basic video on how to import a .CSV file into a table through SSIS. We show you how to...
Read More
So in my day job I was asked to investigate why some data was not matching up. After a bit of investigation I found a table that had 90-95% of it's records duplicated, so I needed a way of removing...
Read More
I've seen alot of questions around the internet about how to remove the time portion from a date. I've provided two ways of doing this below that you can use.
The first uses a CONVERT method, however, CONVERT is...