Here at Database Weekly, we scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week. Here, we have an assortment of the latest articles from selected sources.
At DatabaseWeekly.com you can sign up for the newsletter and browse the latest news.
Currently there is a backup job for the DIFF backup and the script used is;
BACKUP DATABASE [SAMPLE] TO
DISK = N'A:\Backups\Diff\SAMPLE_DIFF_1of3.bak', ...
? INNER JOIN on account_id
? LEFT JOIN CUSTOMER_MSTR with CUSTOMER_TXNS on account_id
? UNION ...
Country codes for the US, UK and DE are US UK and DE respectively.
Date # Customers Revenue US ...
Today we have a guest editorial from Kellyn Pot'Vin that tackles the tough topic of diversity.
This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.
SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult ...
How do you do subqueries in Excel?
SELECT [PurchaseOrderID], [Name]
FROM [Purchasing].[PurchaseOrderHeader] poh, [Purchasing].[ShipMethod] ...
Anthony Nocentino introduces the basics of CPU scheduling in Windows and SQL Server so that when you see things slow down in either of one of these technologies ...
Karthik provides a simple solution to querying a table that has comma separated values.
Ahmad Yaseen takes a look at how to deal with an endpoint encryption compatibility error when using SQL Server's AlwaysOn Availability Group Wizard.
Microsoft's Steve Lasker briefly explains the benefits of using containers compared to VMs
Kong Yang talks through how to deal with security and compliance concerns, support for legacy systems, and budget limitations when implementing cloud ...
In SQL Server Master Data Services all the entities are organized in a model. Once a model is ready to be released to subscribers, it should be frozen ...
The former head of engineering at Rent the Runaway, Camille Fournier, looks at how to measure the success of an engineering team.
Kendra answers a question about early adoption of SQL Server, discusses why testing in production isn't necessarily crazy, and recommends how to handle ...
Arshad Ali discusses SQL Server 2016 Query Store and how it greatly simplifies the performance troubleshooting ...
Julie Rodriguez and Piotr Kaczmarek talk about how visualizations that show comparisons, connections, and conclusions offer analytical clarity.
Vitor Fava looks at how AutoClose property works, and why it's recommended you disable it.
Oracle's lawyers have made their final pitch to paint Google as a copyright outlaw, and the decision is now up to a 10-person jury. Joe Mullin gives some ...
Bradley Ball shares his own Random Workload Generator, and talks through how and why he tweaked the original created by Jonathan Kehayias a few years ...
Though most DBAs don't have the permissions to change the settings in Active Directory (AD) that affect Kerberos, it's still a good idea to understand ...
Moty Fania, principle engineer for big data analytics at Intel IT, talks through the company's internal IoT platform
Oracle is introducing a major new release of its NoSQL database - version of 4.0. Joyce Wells runs through the five key talking points of the new release. ...
Dr. Athanasios Gentimis' field of expertise is Algebraic Topology, with a special interest in Geometric ...
Next week is SQL Saturday #491 in Pensacola. I'll be there, along with a number of other great speakers. It's free SQL Server training, and a great ...
I'm making a website for a private tuition classes. Here, the concept is that a teacher goes to teach to the student's house. There are many teachers ...
In this post we're going to introduce the basics of CPU scheduling.
In a computer system, only one thing can happen at a time. More specifically, only ...
Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback …Continue ...
Today we have a guest editorial from Andy Warren that looks at the decision to leave a job. Or not.
Diagnosing and resolving parallelism-related latching and blocking in SQL Server using DMV's, the activity monitor, procedure execution plans, and index ...
Ayo Olubeko talks through the improvements being made to SQL Server tooling in 2016.
“The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)” error may occurs when executing PowerShell scripts using WMI query.
Microsoft Regional Director and MVP, Troy Hunt, shares his thoughts on the LinkedIn data breach, talks about HIBP, and discusses the broader issues related ...
Gjorgji Gjeorgjievski summarizes the Query Optimizer improvements coming to SQL Server 2016, and explains how you can leverage the benefits of these new ...
Have you ever tried to restore over an existing database only to receive an Msg 3154 error message? You could easily avoid this error by using the WITH ...
Azure storage is a great, inexpensive solution for storing your data in the cloud. There are many types of Azure storage options, but I wanted to list ...
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
When I was a six or seven ...
Recently I created my first Azure SQL Database. But now I need to connect to it.
You can connect using any number of tools. We can actually see several ...
I'm using script component in SSIS to generate insert statements. I'm selecting list of columns from database, then create string covering these ...