SQL Server Migration
Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.
2018-07-20 (first published: 2015-10-12)
8,494 reads
Articles
2018-07-20
5,252 reads
Segment Data into Deciles
This short article shows a simple example of how to segment data into deciles
2018-07-19
10,903 reads
Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4
Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.
2018-07-19
3,727 reads
SQL Server Reporting Services Rest API
What functionality is available in the SQL Server Reporting Services REST API and how should you use it?
2018-07-18
3,886 reads
ETL Performance Auditing - Part 1: Introduction to ETL Auditing
This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2018-07-17 (first published: 2012-06-05)
18,573 reads
Setting Permissions to Drop a Database
Learn which permissions are required to drop a database and see a test to show that these apply.
2018-07-17
22,329 reads
Using SQL Server's Default Trace to Identify Autogrow Events in tempdb
We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately.
2018-07-17
2,946 reads
Fixing ‘A required Privilege is not held by client’ Error
This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out .
A required privilege is not held by the client. The step failed.
2018-07-16
43,156 reads
T-SQL Window Functions and Performance
T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article, Kathi Kellenberger explains what you need to know to get good performance when using these functions.
2018-07-16
4,197 reads
Blogs
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...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers