New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features introduced in each version. In this article, Phil Factor reviews a feature you may have missed, inline indexes. He covers the syntax and the many ways they can be used and then performs some performance tests to see if they can make a difference with table variables.
2019-03-18
3,669 reads
Learn how to use Power BI to retrieve data from an Azure SQL Database.
2019-03-15
2,461 reads
A SQL Server monitoring tool is warning you that you’re getting memory dumps, and you’re wondering what that means.
2019-03-15
2,724 reads
SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.
2019-03-14
2,987 reads
In this tip we cover how you can implement SQL Server cross database referential integrity using triggers.
2019-03-13
2,377 reads
SQL Provision can help organizations ensure compliance with regulations such as HIPAA and SOX. But what exactly are these legislations asking of DBAs and how does this impact the work you do? Robert Sheldon provides an overview of the two US regulations in this four-part series.
2019-03-12
2,407 reads
Azure provides a number of different methods that can be used in order to implement and configure its resources. Each of the methods differs to some extent in regard to functionality and intended use cases.
2019-03-12
1,943 reads
We’re excited to announce that Redgate is doubling its efforts on Oracle and committed to aligning its DevOps solution across both SQL Server and Oracle. Please take a few minutes to complete this short survey to stay up-to-date on our Oracle developments.
2019-03-11
2,174 reads
SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.
2019-03-11
Creating a quick dashboard with a few reports may be the beginning of a BI solution, but unless time is spent on the underlying model, it won't be adaptable enough to grow. In this article by Gogula Aryalingam, you'll see how the advice of a mentor helped a newbie understand how to create a flexible model that will lead to a valuable BI solution.
2019-03-11
2,975 reads
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Comments posted to this topic are about the item What Did Healthy Look Like?
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Telp/Wa 628218200203 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok...
How many types of DML triggers are there?
See possible answers