(Kalen Delaney) I’d really like to get another post up onto my much neglected blog before the end of 2012. This will also start one of my New Year’s resolutions, which is to write at least one blog post a month. I’m going to tell you about a change in SQL Server that wasn’t announced in any “What’s

(Kat Meadows) An interesting request came in the other day, is there a way to tell how much memory each database is using on an instance. You can always use properties to see how much memory is allocated to the SQL Server and there are performance counters available to track how much memory an insta

(Pinal Dave) Backup and Restore are very interesting concepts and one should be very much with the concept if you are dealing with production database. One never knows when a natural disaster or user error will surface and the first thing everybody wants is to get back on point in time when things w

Two recent surveys found that a majority of full-time workers continue searching out job opportunities, usually online and often through social media. What are the pluses and potential pitfalls of continually being on the search?

(Don Jones) Tuning indexes in SQL Server is the one thing a database administrator (DBA) can completely own in terms of database application performance. You can’t necessarily control the queries that an application is firing off to SQL Server, but you can make sure the right indexes are in place to

(Marcin Policht) As we have demonstrated in one of our recent articles dedicated to SQL Server 2012 Integration Services published on this forum, there are several different ways of restricting access to SSIS packages and confidential informationthey contain. However, preventing unauthorized users f

(Khanna_Varun) Today, we will have an overview of two SQL Server functions

(John Garcia) There’s an excellent tip about SQL Server Services, Checking SQL Service Status – An Evolution Part 1, by Robert Pearl. Indeed, this a helpful article, but a very critical piece was missing from it: Which user runs the service. I needed to check which account was associated with the SQ

(Mike Chapple) SQL Profiler is a diagnostic tool included with Microsoft SQL Server 2012. It allows you to create SQL traces that track the specific actions performed against a SQL Server databases. SQL traces provide valuable information for troubleshooting database issues and tuning database engin

(Vishal Gajjar) You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create function with RETURNS NULL ON NULL INPUT, this option introduced in SQL Server 2005.