Usually, a database is meant to serve some kind of application, and .Net applications have a few possible ways to query the database. In...

One of our customers is implementing a very large consolidation project in which they enable users to create their own databases through...

Last week I delivered a seminar in the Expert Days 2012 event by the name of “40 Things You didn’t Know About SQL Server”. The seminar...

Today I’ll show you a special script which will let you “take a snapshot” of your table’s data, and apply it on an identical table...

Here’s what is going to happen today: we’re going to bring a bunch of objects to life, and then we’re going to kill them. Woah, why all...

I remember when SQL server 2008 was first released and I have examined some of its features, when I came across Compression, I was very...

For your convenience, below is a download link to get the presentation and relevant materials for the SSIS Tips & Tricks presentation by...

Once upon a time there was a database. The database was perfectly designed with beautiful tables and views accompanied by good-looking...

SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended...

24 Hours of Pass is tomorrow. If you haven’t registered yet, now is a good time. I expect to: Have little to no sleep time See some cool...