(Kevin Beaver) Just when you think you’ve gotten your SQL Server security under control, a monster rears its ugly head. Up from the dark regions of your network crop SQL Server systems you forgot you had or didn’t even know about. You then realize you’ve only scratched the surface toward having your

(Alexander Kuznetsov) When one and the same constant is copied and pasted in more than one place, there is always a chance that we can change it in one place and fail to change in another, resulting in a discrepancy.

(Siddharth Mehta) Reports designed using SQL Server Reporting Services, have parameters and report data as the two major entities which generally fetch data from database. This is generally facilitated by datasets that fetch data through the medium of a stored procedure. This makes the database logi

(Peter Larsson) This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn’t be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.

(Aruna) We sometimes run into scenarios where an application or a windows service running under Local System Account needs to connect to SQL Server and encounter authentication Errors/issues with SQL Server.

(Alan Cranfield) Partitioning, introduced with SQL 2005 Enterprise Edition, is a godsend for working with very large tables. It provides the means to effectively manage and scale your data at a time when tables are growing exponentially, but maintenance windows are either shrinking or non-existent a

(Marco Russo) I recently talked about memory usage in PowerPivot and previously I wrote about difference modeling options using table normalization or not. Thus, I wondered whether table normalization is a good practice for performance and memory or not. The short answer is that yes, it might be bet

(Baya Dewald) Microsoft’s SQL Server Analysis Services (MSAS) 2005 was a revolutionary release that dramatically changed how software developers and database administrators build and manage business intelligence (BI) solutions. A huge number of new features and changes introduced with this release i

(Alexander Kuznetsov) Whenever we are using multi-statement TVFs, we are essentially forcing nested loops logic on the database engine. Although multi-statement TVFs are smart enough and do not always execute once per row, when they do so, they may be much slower than nested loops.

(Adam W. Saxton) I’ve seen several cases that involved Multi-Value Cascading Parameters and how the behavior of those work. Let me start with the default (Out of the box) behavior. The example report I’ll be using will make use of the AdventureWorksDW sample database. I will also be using SQL 200