Python Jupyter Notebooks in Azure
There’s a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I...
2018-04-27 (first published: 2018-04-18)
3,315 reads
Blog Posts
Top 5 Features of SysTools SQL LDF Recovery Software - Review
An SQL Server Expert Thoughts : I would like to recommend my readers to use SysTools SQL LDF recovery software for viewing transaction log file of SQL Server 2016,...
2018-04-27
17 reads
Top 5 Features of SysTools SQL LDF Recovery Software - Review
An SQL Server Expert Thoughts : I would like to recommend my readers to use SysTools SQL LDF recovery software for...
2018-04-27
1,032 reads
Why Don't I have a Preferred Replica?
The client reported that the log file on their main database was growing unusually large, and when they checked the...
2018-04-27 (first published: 2018-04-18)
4,128 reads
Working with Consultants
After being immersed into the consulting world again for 6 months now, I’ve gotten to work with clients in several...
2018-04-27
456 reads
YouTube Channel Update: 27 April 2018
Despite a hiccup recently on Twitter where I managed to spam all my followers with links to my YouTube videos...
2018-04-27
469 reads
180 – Is It Time For A Turnaround?
What needs to change? The challenge to explore is are there things in your current day to day that needs...
2018-04-26
512 reads
Check health and status of Availability Group using DMVs
-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorumSELECT*FROMsys.dm_hadr_clusterSELECT*FROMsys.dm_hadr_cluster_members
-- Health of the AGsSELECT...
2018-04-26
17,350 reads
dbachecks – Going parallel – Cut off your execution times
On one of the last clients I have worked, I have implemented dbachecks in order to get the state of...
2018-04-26
485 reads
2018-04-26
10 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers