Today I came across an interesting problem with SSRS and ASP.Net. I usually have all my reports optimized to run quickly, this includes creating snapshots revisiting indexes etc. […]
SQL Server Replication Series: – Server is not configured as a distributor.
When setting up a distribution database using the wizard, if you select the second radio button from the below screen you need to already have configured the distribution […]
SQL Server Replication Series: – Configuring the distributor
In this blog we will look at how to configure the distribution database for SQL Server replication. The distribution database is a very important database in replication as […]
SQL Server Replication Series: – Removing Replication
Most times we do not remove replication from a server once it’s been setup but there are occasional scenarios where it may be required. E.g. when decommissioning a […]
Network connectivity issues AWS SQL Express instance
Amazon is one of the premier cloud solutions providers out there and they offer development houses a number of solutions and features that cater to almost any requirement […]
Learning SQL – The column
In this blog I am trying to put the things together a very basic level tutorial on understanding databases and more specifically how to implement one in MS […]
Generate Create and insert scripts for database objects from within SSMS
In this post we explore the option within SSMS which allows the DBA and developer to generate scripts for all data and database objects within SQL Server Database. […]
SQL Server Service fails to start: – Network protocols not enabled
There are a number of reasons why the SQL Server service may fail to start most of the time it has to do with the permissions of the […]
Data mining in SQL Server
While browsing the TechNet forums, I came across a discussion about the future of data mining support in SQL Server. For those who are currently using SQL Server […]
Understanding Indexes and Lookups in SQL Server: Execution Plans and Performance Tuning
This post provides a practical walkthrough on how index creation and modification affect execution plans, particularly in SQL Server 2008 R2 using FactResellerSales and DimProduct tables from the […]