SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in companies large and small. In this article, Eugene Meidinger recounts the history of SSRS and explains when it’s the best tool to use.
2019-01-03
4,119 reads
Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.
2019-01-03
3,952 reads
In this tip we look at different things you should consider when developing your database systems to ensure you are also thinking about security best practices as well.
2019-01-02
2,792 reads
This article was co-authored by Dimitri Furman and Denzil Ribeiro Reviewed by: Danimir Ljepava, Borko Novakovic, Jovan Popovic, Rajesh Setlem, Mike Weiner Introduction In our ongoing engagements with the SQL DB Managed Instance preview customers a common requirement has been to monitor database workload performance in real time.
2019-01-01
2,287 reads
In this tip we learn how to update the Azure SQL Data Mart in an automated way.
2019-01-01
1,758 reads
DBAs running SQL Server on Linux will not only need to understand SQL Server security well, they will also need to understand how security works on Linux. In this article, Kellyn Pot'Vin-Gorman walks you through several examples, explaining the permissions and ownership of files and directories in Linux.
2018-12-31
2,168 reads
2018 is coming to an end, and AGs have been out for 6 years. They're stable now, right?
2018-12-28
2,749 reads
In this article, Feodor demonstrates the architecture, workflow, and some of the challenges of a collaborative platform (cloud foundation) for speeding up enterprises in their search for analytical power. He uses an example from the EA Billing solution, which was presented in the previous articles of the series.
2018-12-27
2,332 reads
In this tip we look at how we can use SQL Server to auto generate a backup script for NetBackup to make sure we backup the required databases.
2018-12-26
1,876 reads
Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!
2018-12-25
2,797 reads
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers