Enjoying a Down Weekend
Steve is looking for entertainment suggestions after the Oscar nominations were released.
Installing R packages in SQL Server R Services
This article shows four ways you can use when installing missing R packages for Microsoft R Services.
The 2019 Data Professional Salary Survey Results
How much do database administrators, analysts, architects, developers, and data scientists make? We asked, and 882 of you from 46 countries answered this year. Y’all make a total of $84,114,940 USD per year! Hot diggety. (And at first glance, it looks like on average, y’all got raises this year.)
Cyber Insecurity in Pakistan
Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.
An Introduction to RLS Security Policies: Level 3 of the Stairway to Row-Level Security
An introduction to how security policies work for RLS.
Cleanup SQL Server Query Store Data After Database Restore
In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.
SSRS Scale Out with Standard Edition Containers and Instances
Learn how to use database cloning to scale out your reporting services workload.
Overview of Azure SQL Database Performance Monitoring
Transitioning to the Platform-as-a-Service model typically implies relinquishing certain degree of control over your computing environment. One of the primary concerns related to this transition is diminished level of transparency providing insights into performance of cloud-resident workloads. Fortunately, with Azure SQL Database, you have a wide range of options that address this concern, allowing you to identify and remediate overwhelming majority of performance-related issues.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers