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.
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.
In this tip we look at how frequently fixes are released for SQL Server.
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.
In this tip we look at how to find and compare differences in system objects between different versions of SQL Server.
In this tip we look at how SQL Server security privileges can be elevated by using some backdoor security settings.
In this tip we look at how to build a SQL Server patch and build release table
Learn how to capture code from SQL Server system objects in Management Studio, PowerShell and SMO to improve your skills.
In this tip we look at ways to find orphaned database users.
In this tip learn how to generate backups based on the amount of data that has changed for differential and transaction log backups.
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.
Learn about how to bulk copy data from Oracle to SQL Server with PowerShell.
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
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
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?
Read this tip to learn how to use R to automatically generate Windows performance counter graphs using T-SQL and R.
Learn how to perform SQL Server database schema synchronization via SQLPackage.exe with PowerShell for stored procedures, views, functions and more.
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.
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.
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.
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.
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.
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.
Learn how to copy a database without any data using DacFx.
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?