Sync SQL Logins and Jobs
In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option...
2017-06-08
681 reads
Time saving trick for PowerShell and CMD
Real quick and simple post for today. Having grown up with a computer since the 80’s, I can tell you...
2017-06-08
539 reads
Top string functions in SQL Server 2017
SQL Server 2017 has been in the talk for its many features that simplify a developer’s life. With the previous...
2017-06-08
612 reads
SSIS To SqlServer DataTypes
SSIS Data TypeSSIS ExpressionSQL Serversingle-byte signed integer(DT_I1)
two-byte signed integer(DT_I2)smallintfour-byte signed integer(DT_I4)inteight-byte signed integer(DT_I8)bigintsingle-byte unsigned integer(DT_UI1)tinyinttwo-byte unsigned integer(DT_UI2)
four-byte unsigned integer(DT_UI4)
eight-byte unsigned...
2017-06-08
1,790 reads
Import Export Wizard Mapping Files
Recently I had to copy data from our AS400 to a SQL Server database. Normally I would whip up my...
2017-06-07
3,883 reads
How to write an UPDATE query
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
142 reads
Data Warehouse Fast Track Reference Guide for SQL Server 2016
I had previously blogged about the Data Warehouse Fast Track for SQL Server 2016, a joint effort between Microsoft and...
2017-06-07
1,278 reads
SQL PowerShell Pre Con at SQL Saturday Chattanooga
I happy to be doing a PreCon at SQL Saturday Chattanooga on Friday June 23rd. A lot has changed in the SQL PowerShell world in the last 15 months...
2017-06-07
8 reads
SQL PowerShell Pre Con at SQL Saturday Chattanooga
I happy to be doing a PreCon at SQL Saturday Chattanooga on Friday June 23rd. A lot has changed in the SQL PowerShell world in the last 15 months...
2017-06-07
6 reads
SQL PowerShell Pre Con at SQL Saturday Chattanooga
I happy to be doing a PreCon at SQL Saturday Chattanooga on Friday June 23rd. A lot has changed in the SQL PowerShell world in the last 15 months...
2017-06-07
15 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers