Security in MySQL: Part One
There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.
SQL Database Snapshots for Reporting, Auditing and Data Recovery
In this article we look at how to create a SQL Server database snapshot and how snapshots can be used for reporting, auditing and more.
Shared Work Spaces: Hell, Heaven, Both?
I've just finished working in my fourth shared work space. I am not a fan. The endless hallways with all these little glassed in rooms where I can see everyone, and everyone can see me, are not my favorite places. I can see white boards with content that maybe I shouldn't be seeing. There are […]
Long Term Storage
Long term data storage isn't something we always need for databases, but it is something the world needs. A new technology has promise for those use cases, both in durability and preserving the algorithms needed.
Migrate the SSIS Catalog in Just a Few Clicks
This wizard migrates SSIS Catalog from one server to another in just a few clicks.
Randomizing the Day Inside a Month Using T-SQL
This article shows how you can randomize dates in T-SQL, but keep the month and year the same while the day varies.
DevOps 101 webinar: The role of Automation
Join Grant Fritchey to discover how automating your database deployments enables you to speed up software delivery with repeatable processes that stop your database being the bottleneck.
Python Try Except Code Samples
In this article we look at how to use exception handling when writing Python scripts along with many different examples using try, except, else and finally clause.
Blogs
Alert Filtering in SQL Monitor
By Steve Jones
SQL Monitor has improved a lot over the last couple of years. We have...
SharePoint List only returns 100 items in Azure Logic App
I was reading a SharePoint List using the “Get Items” activity in an Azure...
Daily Coping 27 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Veritas Net Backup
Hi, We are using SQL 2014 version. The scheduled backup job is failing with...
Database backup and restore
Hello, I've a user database which I want to migrate to new server, so...
Help Implementing Sample SQL Code
Hi community, I am trying to implement sample sql code: SELECT [LocalizedLabel] as [<COLUMN_NAME>]...
Ask SSC