Blog: SQLUndercover


209 blogs updated: 51 min. ago
SQL Smackdown!!! Cursors VS Loops
Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the World! In the ...
15
16-11-2017 14:32:00 SQLUndercover SQL Server
T-SQL Tuesday #96 - Folks Who Have Made a Difference in my career #TSQL2sday
This months TSQL Tuesday subject is a shout out and high-five to those people who have inspired or made a contribution to my DBA life. So he...
12
15-11-2017 06:29:05 SQLUndercover SQL Server
T-SQL Tuesday #96 How did I get started?
Hi Folks, I'm the new guy that my two colleagues are still trying to convince to write my first blog post and as they like to put it I'm sti...
5
14-11-2017 23:48:18 SQLUndercover SQL Server
T-SQL Tuesday – Folks Who Have Made a Difference #TSQL2sday
So this month's T-SQL Tuesday subject is a shout out and high-five to those people who have inspired or made a contribution to my DBA life. ...
5
14-11-2017 15:50:07 SQLUndercover SQL Server
UNDERCOVER TOOKBOX: Using Python To Copy A SQL Login From One Server To Another
Recently I've been thinking about Python and whether it can be useful to the DBA as well as the data scientist. One good use that I have fou...
7
30-10-2017 16:19:45 SQLUndercover SQL Server
UNDERCOVER TOOLBOX: Find Untrusted Foreign Keys and Orphaned Key data
SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of reasons why a For...
5
24-10-2017 12:59:56 SQLUndercover SQL Server
Connecting to a Remote Instance of SQL Server Using Python
SQL Server's integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer anything for the DB...
5
18-10-2017 18:56:10 SQLUndercover SQL Server
How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far
I'm pretty sure that we've all found ourselves in the situation where we've run an INSERT, UPDATE or DELETE script and it seems to be taking...
17
05-10-2017 15:54:17 SQLUndercover SQL Server
Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .
Routine maintenance rolls around and it's time to failover your AG's to new Primary's to allow for patching and restarts the weapon of choic...
6
04-10-2017 13:04:19 SQLUndercover SQL Server
SQL Mirroring, Preserving the Log Chain During Database Migrations
Originally posted on SQL Undercover: Database mirroring has been deprecated since SQL Server version 2012 and now with the advent of SQL 201...
7
03-10-2017 10:24:59 SQLUndercover SQL Server


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.