By Ginger Daniel | Beginner , Miscellaneous , SQL Development , SQL Server
— by Ginger Keys Having duplicate records in a database is an age-old problem that almost every organization has to deal with. Duplicates can appear because of careless data input, merging records from old systems into new systems, uploading leads from purchased lists, and multiple other reasons. Identifying these duplicate records can also be tricky. […]
Continue readingBy Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server
Beginning with SQL Server 2012 and beyond, Microsoft has developed a new feature in all editions of SQL Server that allows us to create databases independent of the instance hosting that database. In this article I will cover some of the features, pros and cons, and how to create a contained database. What is it? […]
Continue readingBy Ginger Daniel | Advice , Miscellaneous , Perfmon , SQL Administration , SQL Server
–by Ginger Keys Recently, a client of mine contacted me in a panic because CPU was running at 99-100% over an extended period of time, which was affecting everything on the machine. We’ve all seen it at one time or another. And there are several reasons this could be happening. It could be SQL consuming […]
Continue readingBy Ginger Daniel | Helpful Scripts , SQL Administration , SQL Server
–by Ginger Keys AlwaysOn Availability Groups is a great new feature of SQL 2012 and 2014. This feature is a combination of database mirroring and failover clustering, and it provides a strong level of high availability and disaster recovery; however there is no straightforward monitoring/alerting processes to go along with this new functionality. It is […]
Continue readingBy Ginger Daniel | Performance Tuning , SQL Administration , SQL Server , Windows
Recently, a client of mine contacted me in a panic because almost all of the memory on the SQL server was used up…according to Task Manager, that is. Don’t panic…task manager is probably lying. Well, a little bit anyway. And Task Manager is just that, a task manager. If you are looking at it to […]
Continue readingBy Ginger Daniel | Installation , SQL Administration , SQL Server
After you make sure you have everything in your environment ready to go and all the prerequisites that need to be done before deployment have been done, we are ready to install the AlwaysOn Availability Group! The following steps need to be performed in this order: Add Windows Failover Clustering (WSFC) to each replica (server) […]
Continue readingBy Ginger Daniel | Installation , SQL Administration , SQL Server
Before implementing your AlwaysOn Availability Group, make sure you have everything in your environment ready to go. There are several prerequisites that need to be done to ensure a successful deployment. These prerequisites focus on your Windows environment, the SQL instances, and the databases to be included in your AlwaysOn group. Windows: Windows Server 2008 […]
Continue readingBy Ginger Daniel | SQL Administration , SQL Server
AlwaysOn is a great new feature in SQL Server 2012 and 2014 Enterprise edition. It has been described as the next evolution of database mirroring. AlwaysOn enhances the existing technologies of database mirroring and failover clustering to provide a strong layer of high availability and disaster recovery. The way it works is that you have […]
Continue reading