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,373 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
963 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
697 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,615 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
2,117 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
570 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
561 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
444 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers