Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.
2019-06-18
The JSON documents that are part of Cosmos DB document collections can be complex with arrays and nesting. In this article, Adam Aspin shows you how to query them with SQL.
2019-06-17
In this article, Kathi Kellenberger demonstrates how to create a project and report using the SSRS Report Wizard. The wizard is fine for getting started, but you’ll soon learn about its many limitations. She also explains how reports fit in projects and solutions.
2019-06-14
Learn about options to copy a table from one SQL Server database to another including Linked Servers, PowerShell, Integration Services, backup and restore along with the associated performance metrics and completion time.
2019-06-13
In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.
2019-06-12
A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement in either situation is bad. In a perfect world, a DBA will be productive and not spending most of their time “putting out fires.” (And fires are never a good idea on a flight!)
2019-06-10
Whether you’re looking to go cutting-edge and hop on SQL Server 2019 as soon as it’s available, or whether you’re just trying to evacuate from SQL Server 2008 to anything that’s going to be supported after this summer, you’re probably doing upgrade projects. This is a good time to ask yourself 5 questions...
2019-06-07
In this second part of this tip series we take a look at the dplyr package for R that can be used to query data using the R Language with SQL Server and build data visualizations.
2019-06-07
In this independent review of SQL Provision, the Bloor analyst finds that SQL Provision’s combination of database cloning and data masking stands out with “clear advantages over competing approaches, such as data subsetting or synthetic data generation.”
2019-06-06 (first published: 2019-05-23)
In this tip we look at code you can use to convert an integer date into a datetime format. This is an issue you will face when working the history data for SQL Server Agent Jobs.
2019-06-06
Not really, but sort of. The beauty of containers, at least in a dev/test...
If you are being serious in your role, then the amount of times you...
I recently did a post on the case expression short circuting and received a...
Comments posted to this topic are about the item Statistics Profile Results
Hello, I have a question and I don't know if it's possible to configure...
I need to add the subtotal between the tablix and subreport, I need to...
Ask SSC