SQL Server Storage best practices
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,083 reads
Forrards Group Database Blog
Pros and Cons of Switching to Database Managed Services
What are exactly Database Managed Services?
The term is widely used and covers so many things simultaneously, so it is hard...
2015-07-07
763 reads
10 Best Advices to Choose an SQL Consulting Firm
Managing SQL Server can be exhausting, so more and more companies today choose either to delegate this task to some...
2015-07-06
664 reads
SQL Server transactional replication performance tuning and optimization
If you`re using transactional replication on SQL Server platform on rather large and data intensive environment you may have faced...
2015-07-02
1,343 reads
How to bulk enable or disable SQL Server agent jobs ?
It often happens that you need to disable or enable all jobs in SQL Server Agent in one shot. Script...
2015-06-22
1,753 reads
SQL Azure pricing
Form the first glance it may seem to be complicated to calculate price of hosting your database on Azure SQL. We`re simplifying this...
2015-06-17
560 reads
Hints on choosing a remote database support service
Databases today are the heart of any business. Holding literally tons of information they indirectly are responsible for managing personnel,...
2015-06-17
535 reads
10 Things a Database Design Company Should Do
Database design is a complex industry involving many technologies, software and specialists. The term “design” is a little bit misleading...
2015-06-11
440 reads
Blogs
The Effectiveness of Solar Estimation
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and...
Daily Coping 24 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Shared Work Spaces: Hell, Heaven, Both?
Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...
T-SQL : Slicing time Islands and gaps
Hello, Consider the following table that gives the validity dates of an item :...
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
Ask SSC