There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.
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.
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 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.
This wizard migrates SSIS Catalog from one server to another in just a few clicks.
This article shows how you can randomize dates in T-SQL, but keep the month and year the same while the day varies.
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.
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.
By Steve Jones
SQL Monitor has improved a lot over the last couple of years. We have...
I was reading a SharePoint List using the “Get Items” activity in an Azure...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, We are using SQL 2014 version. The scheduled backup job is failing with...
Hello, I've a user database which I want to migrate to new server, so...
Hi community, I am trying to implement sample sql code: SELECT [LocalizedLabel] as [<COLUMN_NAME>]...