Connection to SQL Server Works Sometimes Stack Overflow
An ADO.Net application is only sometimes able to connect to another server on the local network. It seems random whether a given connection attempt succeeds or fails. The connection is using a
Getting Started With SQL Server 2012 CLR User ... SPR
Here is a quick tutorial on how to implement SQL Server 2012 CLR user defined functions that you can use instead of straight T SQL.
New Line Issue when copying data from SQL Server 2012 to ...
I recently upgraded to SQL2012 and am using Management Studio. One of my columns in the database has a CHAR(13) CHAR(10) stored in it. When I was using SQL Server 2008, this would copy and paste completely fine into Excel.
An Introduction to SQL Server Clusters with Diagrams
The options for high availability can get confusing. I was lucky enough to begin working with SQL Server clusters early in my career, but many people have a hard time finding simple information on what a cluster does and the most common gotchas when planning a cluster.
sql server SQL 2012 Transaction Log backup does not ...
Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
SQLskills SQL101: Dealing with SQL Server corruption
Quick guidelines for how to approach SQL Server corruption.
Understanding SQL Server Backup Types sqlshack
SQL Server backups, in itself, is a vast subject; so vast, there are multiple books written about them. In this article, however, we are going to focus on the types of backups that are available to us, and understand how to pick what we need, and what aspects we base that decision on.
Bug: database server 'shutdown due to error 3314' Paul S ...
Yep hit this multiple times on SQL 2012 in 2015. Worst it was production and the log was multiple TBs so took about 6 hours to come online (compounded by slow disk issues).
Window Functions in SQL Server Simple Talk
When SQL Server introduced Window Functions in SQL Server 2005, it was done in a rather tentative way, with only a handful of functions being introduced. This was frustrating, as they remove the last excuse for cursor based operations by providing aggregations over a partition of the result set, and
Simple script to backup all SQL Server databases MSSQLTips
Sometimes things that seem complicated are much easier then you think and this is the power of using T SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server. This is not a big deal if you have a handful of databases, but I have seen several