Data Savvy

My Preferences for SSIS Design

Lately, I have been using SSIS execution frameworks and Biml created by other people to populate data marts and data warehouses. It has taught me a few things and...

2019-08-20 (first published: )

1,010 reads


Who needs data access? Not You!


With a little planning and care, we can find various ways to fulfill user...

Azure Synapse Analytics & Power BI performance


With two new relational database features (Result-set caching and Materialized Views) just GA’d in...

Session Evaluations from “SQL Server Security from the Ground Up”


I was recently given the opportunity to speak at Pass Summit. As always (this...

Read the latest Blogs


Data drive

By Admingod

Data drive is full not the log space. If it is ldf then yes,...

Need Help formatting query to pull date-related data from Table

By bkufleitner

I need help correctly formatting the following query to pull some date-related records: This...

t-sql 2012 insert into a temp table

By wendy elizabeth

Can you show me a better way to place hardcoded values into a sql...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers