SQL Server Bulk Insert for Multiple CSV Files from a Single Folder
Check out this article to see how to quickly import into SQL Server many files with the same structure using T-SQL.
2020-08-11
SQL Server
How to Expand a Range of Dates into Rows using a SQL Server Numbers Table
In this article we look at different T-SQL code examples that can help you build a range of date rows based on a starting and ending date.
2020-07-28
Using SQL Server Query Store & Plan Guides to Fix Problem Queries
This webinar will cover how to use SQL Server plan guides and the query store to fix problematic queries and ways to improve query performance.
2020-07-14
Setting up Management Studio for remote SQL Server
Learn how to configure SQL Server and Windows to allow others to connect to an instance remotely.
2020-01-06
76,109 reads
Update only Year, Month or Day in a SQL Server Date
In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.
2019-12-17
A Big Week for the Data Platform
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
216 reads
Getting Started with SQL Server on Google Cloud Platform
Learn how you can create a SQL Server instance in the Google Cloud Platform.
2019-09-26
3,274 reads
2019-09-14
248 reads
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
2019-06-20
220 reads
Are your CPU-intensive queries running slowly? Check your VM type.
When you build a VM for SQL Server in Amazon EC2, Azure VMs, or Google Compute Engine, it’s all too easy to overlook the CPU speeds that you’re getting. Brent Ozar explains when to stop and check the VM type you used when building this VM.
2019-05-24
1,077 reads
Blogs
The Community is YOU, Not Any Organization
As I type this, we’re leaving behind spring, and all the amazing events that...
Polyglot Persistence
By Steve Jones
I’ve seen the term polyglot persistence floating around Redgate a bit recently in the...
Six Months!
Oh good gosh. Six months without a single blog post. Most important information: I’m...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers