Using Regular Expressions to Manipulate Text in SQL Server Management Studio 2017
In this tip we look at how we can use the built-in RegEx features in SSMS 2017 to manipulate and reformat T-SQL code.
Jeffrey Yao is a senior SQL Server consultant with 15 years of database administration, his current interests are on database administration automation and visualization. He enjoys reading the concise and smart sql tips and loves R&D work in DBA Engineering topics. His blog is at: http://www.sqlservercentral.com/blogs/jeffrey_yao/.
SQL Server HotFix History Analysis
In this tip we look at how frequently fixes are released for SQL Server.
Extract Hot Fix Details from a SQL Server CU KB Articles
In this tip we look at how to automate getting information about SQL Server cumulative updates and hot fixes, so you can quickly and easily determine if you should apply the updates to your SQL Server instances.
Identify System Object Differences Between SQL Server Versions
In this tip we look at how to find and compare differences in system objects between different versions of SQL Server.
Backdoor to Elevate SQL Server Security Privileges
In this tip we look at how SQL Server security privileges can be elevated by using some backdoor security settings.
Creating a SQL Server Build and Patch Release Table
In this tip we look at how to build a SQL Server patch and build release table
Learn SQL Server from Microsoft’s Own Code
Learn how to capture code from SQL Server system objects in Management Studio, PowerShell and SMO to improve your skills.
Different Ways to Find SQL Server Orphaned Users
In this tip we look at ways to find orphaned database users.
Create Size Based Backups for SQL Server 2017
In this tip learn how to generate backups based on the amount of data that has changed for differential and transaction log backups.
Build a Robust Incremental SQL Server Update Statistics Procedure
Learn how a robust on-demand incremental SQL Server statistics update process on partitioned tables will boost performance stability, reduce resource consumption (I/O and CPU) and significantly shrink the maintenance window for very large tables.
Bulk Copy Data from Oracle to SQL Server
Learn about how to bulk copy data from Oracle to SQL Server with PowerShell.
The 6 Rules to be a Happy SQL Server DBA
To be a DBA, one has to be stress and pressure proof to deal with daily multiple tasks, flooding alerts, on-call standbys or some midnight wake-up calls. Without some principles, one can easily get drown in troubled water. As a DBA for many years, do you
Visual SQL Server Performance Data Comparison with R
As a SQL Server DBA, we usually need to collect various performance counter data or other query performance data via Extended Events (XEvent) or Trace. After collecting these data, one common use is to compare the data of troubling time with the data of t
Exploring SQL Server Table Backup Methods
There are times when a SQL Server DBA needs to backup (both schema and data) one or more tables out of a large database, so the table can be restored/recreated in another environment. What kind of methods can I use to backup a SQL Server table?
Generate Performance Counter Graphs with SQL Server and R
Read this tip to learn how to use R to automatically generate Windows performance counter graphs using T-SQL and R.
SQL Database Schema Synchronization via SQLPackage.exe and PowerShell
Learn how to perform SQL Server database schema synchronization via SQLPackage.exe with PowerShell for stored procedures, views, functions and more.
SQL Server 2016 Regular Expressions with the R Language
With the power of the R language and its native support for RegEx, we can now query a SQL Server table with Regular Expressions through R.
Implement a Comment Based Help Framework via CLR Stored Procedure
Learn how to implement a comment based help framework for database objects (stored procedures, views, user defined functions, etc.) via a SQL Server CLR stored procedure.
Advanced Use of the SQL Server ORDER BY Clause
Learn the advanced use of the SQL Server ORDER BY clause including random data, offset and fetch, calculate the median, case statement and row_number with partition.
Copy data to another SQL Server instance without a Linked Server
In this tip we look at how to use R to copy data from one instance of SQL Server to another instance without using a linked server.
Easily Import CSV Files with R in SQL Server 2016
To load csv files with just T-SQL is often a headache depending on the contents and the format of the csv files. In this tip we cover an easier way to do this using R.
Delete Files with SQL Server 2016 R Logic in T-SQL Code
How can I delete files older than [X] days in a folder using T-SQL? The typical T-SQL solution is to use xp_cmdshell or an undocumented SP xp_delete_file. Learn how you can use R logic in T-SQL scripts to solve this issue.
Copy a SQL Server database with just the objects and no data
Learn how to copy a database without any data using DacFx.
Technical Interview Questions for a Senior SQL Server DBA
We need to hire a new senior DBA. What are some of the questions we could ask to host a quality technical interview to assess a candidate?