Monday, August 31, 2015

SQL Server Brain Basher of the Week #027 - Business Intelligence

›
Well known three functionalities provided by a business intelligence solution are; Drilling down , Drilling through and Slicing and dicin...
Sunday, August 30, 2015

Changing authentication mode without using management studio

›
.Microsoft SQL Server can be accessed using logins created with Windows accounts/groups or logins created with SQL Server instance. Access...
Saturday, August 29, 2015

Why we need Analytical Data Models?

›
Among the key elements of business intelligence solution such as data sources, ETL, data warehouse and data models, data models play a maj...
Thursday, August 27, 2015

Free Xamarin Subscriptions for Windows Phone Developers

›
Are you developing Apps for Windows phone and looking for a free subscription for Xamarin? Here is a chance, grab it before 31st of August...
Wednesday, August 26, 2015

Product review: CloudBerry Backup - Cloud Backup for Microsoft SQL Server

›
One of the important assets to an organization is data, because it holds valuable information related to the business, such as customers i...
Tuesday, August 25, 2015

Who modified my tables: tracking SQL Server table changes

›
What is the easiest way of capturing changes on tables? I was asked this question and what immediately came to my mind was DDL Triggers . ...
Sunday, August 23, 2015

SQL Server Brain Basher of the Week #026 - Variable types

›
Similar to other programming languages, SQL also offers a facility to create variables for holding values temporarily. Variables are creat...
Friday, August 21, 2015

Deleting records based on another table: Should I use standard delete or non-standard delete statement?

›
When you have to delete records from a table based on a filter set with another table, what type of statement generally you use? DELETE ba...
Thursday, August 20, 2015

Stored procedure parameters: Setting default values with functions

›
Stored procedures are common objects in SQL Server databases as it gives many benefits for us. One important thing with Stored Procedure i...
Wednesday, August 19, 2015

Encrypting backups and restoring encrypted backups

›
Your applications cannot be survived without database backups! Database backup is a fundamental requirement and it is the key task amo...
Monday, August 17, 2015

SQL Server Brain Basher of the Week #025 - DMVs and DMFs

›
The best and easiest way of getting real-time state information and recent historical information related to SQL Server is using Dynamic M...
Sunday, August 16, 2015

Differences between BCP and BULK INSERT

›
It is not uncommon to see importing data from other sources and exporting data into other sources as not all data can be entered row-by-ro...
Saturday, August 15, 2015

Finding user tasks that are waiting longer than expected time

›
Performance tuning is one of the common operations in database world and is always done for optimizing queries. When performing Performanc...
Friday, August 14, 2015

Can I disable all constraints when loading data?

›
Generally, when loading a large data set, we disable constraints and drop indexes for speeding up the loading process. Constraints help us...
Thursday, August 13, 2015

Ways of seeing Query Execution Plans

›
When it comes to troubleshooting, most of the time, first thing we do is, checking the query execution plan related to the query for under...
Tuesday, August 11, 2015

Granting only SELECT permission on all tables on all databases quickly

›
Different requirements pop up at different time, unexpectedly. What if someone needs to access all your databases and needs to see all rec...