Importing a CSV into SQL Server Shouldn't Be This Hard
A frustrating time importing CSV files leads Steve to test the different options.
2021-07-14
6,508 reads
Steve Jones
- Interests: yoga, reading, biking, skiing, volleyball
Data Saturday #8 - SouthWest US
This Data Saturday Event is being jointly developed by the Albuquerque Data Platform Users Group, Arizona Data Platform Users Group, and the Santa Fe Data Platform Users Groups. This event will include sessions on many Microsoft Data Platform related topics. Join us on May 15, 2021.
2021-05-14
Reducing the Frequency of SQL Server Central Newsletters
We are reducing the sending of the SQL Server Central newsletter to three days a week.
2021-04-30 (first published: 2021-04-26)
1,045 reads
Converting Binary Numbers To Hex
A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.
2021-04-09 (first published: 2018-11-27)
7,911 reads
2021-04-01
7,218 reads
2021-03-26 (first published: 2018-12-10)
10,669 reads
Email Issues with SQLServerCentral
We are experiencing some email issues with our sender. There are some spam reports for our newsletter, which are causing us issues. If you have any questions, please contact the webmaster@sqlservercentral.com.
2021-03-23
75 reads
Using Non-SQL Languages in Azure Data Studio
In this article, we examine the support for non-SQL languages in Azure Data Studio, primarily PoSh and Python.
2021-03-16
2,241 reads
Redistributing Data Across Files
When adding files to a filegroup, SQL Server doesn't automatically balance the data across the files immediately. See how this works and how you can speed this up.
2021-02-19 (first published: 2019-11-07)
7,695 reads
Getting Comfortable Writing Code in Azure Data Studio
Learn some of the ins and outs of working with Azure Data Studio to develop SQL code.
2021-02-15 (first published: 2019-03-25)
6,408 reads
Blogs
Data Modeling at your fingertips
By Rayis Imayev
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...
How to put a SQL Server Database into Recovery Pending
By John
You might be asking why on earth would you want to get a database...
Daily Coping 30 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Migrate SQL Sever 2012 Database To Server 2014 and Subsequent Versions
Hi Guys, I have an SQL Server 2012 Express database that I would like...
Deploying SQL Server Automatically
Comments posted to this topic are about the item Deploying SQL Server Automatically
Setting data compression on a database or even server level possible?
I well realize data compression is a subject to a few variables, such as...
Ask SSC