SQL Server Connections Discount Code
If you are thinking about attending SQL Server Connections (a part of DevConnections) in Orlando this March 27-30, take advantage...
SSRS Report Parts Versus Sub Reports FAQ
I'm trying to decide on a development strategy to satisfy the reporting needs in my organization. I would like to increase our efficiency in responding to report requests, while minimizing our maintenance burden. Two topics that I would like to dig in to are Report Parts and Subreports. Can you provide some considerations for using one versus the other?
DBA Concerns
A survey of Oracle DBAs shows them having a number of security concerns. Steve Jones thinks that a survey of SQL Server DBAs would be similar.
The EXCEPT and INTERSECT Operators in SQL Server
The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. Rob Sheldon explains all, with plenty of examples.
Quality Over Timing
Is quality job one for software companies? Steve Jones asks what you think and comments on why quality might not be as high as we would like.
Hiding System Objects in Object Explorer in SQL Server Management Studio
While looking through the new features and improvements in SQL Server Management Studio (SSMS) we found a potentially interesting one to Hide System Objects in Object Explorer in SQL Server Management Studio. In this tip we will take a look at how to Hide System Objects in Object Explorer.
SSRS – Creating and Using Shared Schedules Part 4
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
SSRS: My Filter is not Working!!!
I rarely use filters in my SSRS reports. However, this was a client requirement. When we attempted to use the...
Avoiding Logging
It seems that some people think that you can perform actions in SQL Server without logging them in the transaction log. Steve Jones talks about this myth and says it's not even an option he'd like to have.
RedGate Source Control for SQL Server Webinar from Pluralsight
Join this webinar from Pluralsight, a very well known developer training company. Learn how SQL Source Control can help you keep track of your code.
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Can/Can't Do/Don't
Comments posted to this topic are about the item Can/Can't Do/Don't
Strange String Splits
Comments posted to this topic are about the item Strange String Splits
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers