When does it make sense to hire a data science consulting company?
Going into 2019, data science and machine learning is all the hype. Organizations in every industry are starting to realize...
2019-01-06
27 reads
Marc Beacom
I’m Speaking – Denver Dev Day Fall 2018
Denver Dev Day Fall 2018 is a free event organized by volunteers and hosted at the Microsoft campus in the DTC. It’s a full day to learn from industry...
2018-10-12
It’s a wrap – SQL Saturday Denver #774
SQL Saturday Denver #774 has come and gone. It’s hard to believe how quick things went – well there were a...
2018-10-12
362 reads
Cloud ETL for the Modern Enterprise Workshop
We are introducing a new workshop focused on Cloud ETL. ETL, or Extract, Transfer and Load, is nothing new and...
2018-09-26
292 reads
Advance Your Business by Embracing Cloud Technologies
Advance Your Business by Embracing Cloud Technologies In a rapidly shifting economic landscape filled with supposed cost-cutting strategies, no solution...
2018-08-19
254 reads
Automating Database Deployment: Part 4 Making Changes Using RoundhousE to Migrate the Database
With the Automating Database Deployment: Part 3 Running RoundhousE post we walked through running a RoundhousE deployment for the first time to create the database and several database objects. Script naming...
2018-02-28
Automating Database Deployment: Part 3 Running RoundhousE
Now that we have a basic understanding of RoundhousE database deployment from the first two parts of this series let’s get to the good stuff. If you haven't read...
2018-02-21
Automating Database Deployment: Part 2 Setting Up the RoundhousE Environment
Remember from the introduction that RoundhousE is a command line driven database deployment engine. This article of the series will discuss the deployment flow and the RoundhousE environment, looking...
2018-02-19
Automating Database Deployment: Part 1 Introduction to RoundhousE
Database Deployment in DevOps One of the many obstacles to database development and DevOps is how to deploy databases consistently and how to automate the process. Database deployments have...
2018-02-12
AWS EC2 Linux AMI with pyodbc
AWS EC2 Linux AMI with pyodbc, psqlODBC, Microsoft ODBC Drivers Context: Using pyodbc within a small python application to pull tracking data from an Azure SQL Server DB, do...
2018-01-23
1 reads
Blogs
Storage Field Day 23 – HammerSpace
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Daily Coping 16 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Why You (usually) Want a Clustered Index
By alevyinroc
Note: I originally wrote this a few years ago but never posted it. It...
Forums
Migration of Data from one Database to Multiple Databases
Hello, I have a requirement to migrate the data from existing AWS RDS DB...
AWS Beginner questions
I'm having some trouble wrapping my head around the relationship between EC2 instances and...
How to get weekly and Monthly view from daily in sql server
Hello All, I have a table like below. I need to get daily,weekly and...
Ask SSC