Tag Archives: MSSQL

SQL Server does not start with %%17051 error

SQL Server might not start from all variety of reasons including permission issues, master database not available or corrupted, service account issues, etc. In this article I will talk about diagnose of failed service start and how to fix %%17051 … Continue reading

Posted in Microsoft SQL Server | Tagged , , , | 9 Comments

Microsoft SQL Server Myth #2

Shrinking your transaction log makes your backups smaller. FALSE

Posted in Microsoft SQL Server Myths | Tagged , , , , | 2 Comments

Backup and Disaster Recovery Plan – Part II

In my previous article I described my database recovery attempts in company without ANY backups. Today I would like to talk about making of BDRP. All the time we protect ourselves our property our cats against disaster with insurance. That’s … Continue reading

Posted in Microsoft SQL Server | Tagged , , , | 4 Comments

Backup and Disaster Recovery Plan – Part I

Last Friday night (no T.G.I.F) Last week a friend of mine called that his customer’s hard drive failed but was able to do a bite copy of damaged drive. Few bad sectors were within MDF file. My first question was … Continue reading

Posted in Microsoft SQL Server, SharePoint | Tagged , , , , , | 3 Comments

Get first and last day of month in SQL 2012 and SQL 2008 and earlier

This article has been reviewed, improved and moved to my new blog http://blog.hubacek.uk/get-first-and-last-day-of-month-in-sql-2012-and-sql-2008-and-earlier/ Today I had to create an ETL for batch loading of records into data warehouse for the current month. For this I had to get first and last day … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , , , , , | 4 Comments

Use your text / CSV files in your queries via OPENROWSET

This article has been reviewed, improved and moved to my new blog http://blog.hubacek.uk/use-your-text-csv-files-in-your-queries-via-openrowset/ On Friday I was asked by my friend whether I could help him with text file access via OPENROWSET with Ad Hoc Distributed Queries. So I stopped by to … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , | 3 Comments

Microsoft SQL Server 2008 R2 Service Pack 2 Released (10.50.4000.0)

Microsoft has released second service pack for SQL Server 2008 R2 (10.50.4000.0). It contains generally all hotfixes provided in SQL Server 2008 R2 SP1 CU 1 to 5. Some of the hotfixes are highlighted at Technet’s blog:

Posted in Microsoft SQL Server | Tagged , , , , , , | Leave a comment