(Dinesh Asanka) How do you attach and detach databases in SQL Server? What is the difference between a SQL Server backup and restore vs. detach and attach?
Tag: sql server
(Maria Colgan) At the recent OOW European conference there was a lot talk about Converged Databases and how they can greatly simplify data driven app development.
(Pinal Dave) In the past, I have written a few blogs where I explained a few issues about the failure of listener creation Failure in a cluster. In this blog, we would see another cause of listener creation failure.
(Tim Radney) Azure SQL Database Managed Instance became generally available in late 2018. Since then, many organizations have started migrating to Managed Instance for the benefits of a managed environment.
(Gregory Larsen) For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.
(Ken Simmons) As a DBA for several servers, I get a lot of calls about disk space. The first thing I do is look for data files I can shrink to free up some space on the disk. Some of the servers I support contain several databases and it can take a while to figure out which data file will […]
(Margaret Rouse) Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another — so that all users share the same level of information.
(Pinal Dave) During the recent consulting engagement Comprehensive Database Performance Health Check with SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.
(Jeremy Kadlec) Accurate data is imperative for an organization to conduct cost effective decision making, marketing promotions, mailings, database bloat impacting performance, storage and more. Like everything else, change is constant for your data. There is a need to cleanse and validate data wh
(Pinal Dave) The other day, I was helping my client of the Comprehensive Database Performance Health Check, and during the engagement, I provided a few scripts which they can use to tune their system. During the engagement suddenly a Jr. DBA asked me if I have a query that will list all the jobs in