Very few people have thought about this performance killer. It is all about report parameter of text type.
The initial situation
There...
2015-11-04 (first published: 2015-10-22)
2,155 reads
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning...
2015-10-14
1,101 reads
If for any reason you need to place the database on a network share and by default this option is...
2015-10-12
460 reads
I decided to check if there is still database mirroring option in MS SQL Server 2014
Wow! It works!
MIrroring is still...
2015-10-08
584 reads
I want to share my way to convert a string to Base64 and back. Let me note that presented method...
2015-09-30
1,818 reads
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was...
2015-09-25
1,115 reads
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you...
2015-09-24
1,011 reads
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful...
2015-09-22
842 reads
The dba routine includes developer’s accounts management. Such as creating sql logins for new developers. There is usually a standard...
2015-09-14
1,876 reads
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly....
2015-09-10
1,542 reads
By Brian Kelley
I recently received the news that I’ve been renewed as a Friend of Red...
I’ve been very blessed to be able to work for Redgate Software. We’ve done...
Extended Events can do things that simply are not possible with Profiler and another...
I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...
Hi, I want to run the below query to get information about the tables...
Hello SSC, I am looking for a simplified way to track which user created...
Ask SSC