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.
We are trying to load a table from SQL Server Parallel DW APS to In-Memory OLTP SQL Server 2014 Enterprise edition. As we are aware that we have ...
please kindly tell me the answer for the attached picture.
I have a database with 100 tables. I have a main customer table (Primary Key CutomerID) and need to archive all customer records where status = ...
I given a task for auditing any DDL changes in one particular server instance. There are a few databases on the server and I cannot create any objects ...
can someone help me prevent this deadlock
I have 2 Tables, Say table A and Table B, Table B has foreign key relation with Table A and while inserting ...
Good afternoon,I am trying to compare the clustered and nonclustered count and their definitions ...
SQL Server 2016 SP1 opens up a lot of new possibilities for Standard, Web, and Express editions of SQL Server, including new options for in-memory technologies ...
Microsoft's February Patch Tuesday patches are not going to arrive until Tuesday March 14, officials confirm, while providing no reasons for the delay. ...
In his ongoing series about chatbots, Benjamin Perkins now talks us through some recent improvements he's made to his own chatbot.
The latest version of Microsoft SQL Server, dubbed SQL Server v.Next, is due out soon after being in public preview mode since last year. From the looks ...
Scott Larsen walks through the steps of creating a Power BI visualization based on Hans Rosling's 2006 TED talk.
Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.
SQL Server 2016 and Azure SQL Database enable you to parse JSON text and transform it into tabular format. In this post, you might see that JSON functions ...
Want to quickly find all the function definitions within a module? Or the function calls within a function definition? Stuart Moore shares a regex he's ...
In this free online training course from Kendra Little, learn to set up simple, lightweight monitoring using free tools and scripts to find the queries ...
In a bid to spread greater understanding about the role, Thomas LaRock gives a summary of the day-to-day tasks that are common for a DBA.
In this free webinar, Steve Jones and Arneh Eskandari show how Redgate's Database DevOps solution works with Visual Studio Team Services to improve your ...
Drew Furgiuele talks about how he had the chance to be involved with dbatools, the exciting community-created PowerShell module that adds functions to ...
Grant Fritchey shares a PowerShell script he's written that exports query plans from the plan cache into a .sqlplan file.
This is a different spin on the top three vendor rankings visualized in Power BI. According to the placement of the chart elements in the "Visionary/Leader" ...
One of the wow moments in the keynote where SQL Server 2016 was first introduced was a demo that automated the process classifying images of galaxies ...
Kenneth Fisher talks through how he dealt with a database stuck in single user mode.
In the latest episode of Dear SQL DBA, Kendra Little clears up the confusion surrounding sp_who2.
Henrico Bekker runs through a performance comparison of SQL Server against SQL Server on Linux.
On the theme of fixing old problems with shiny new toys, Steve Hughes takes a look at splitting strings ...
Andrew Pruski shares a key step to viewing Docker logs that can trip you up if missed out.
Led by its Technology Solutions team, Avnet will team with IBM to establish a Watson Internet-of-Things Joint Lab within IBM's newly opened global Watson ...
I want to calculate bell curve report and data display in google chart.
How to calculate bell curve report from give data?
From time to time, I see posts in forums from people complaining about how much some consultants charge. A really good consultant is never going ...
Is it me or is February dragging? Anyway, mixed in with this crazy week I’ve been reading: –
SQL Server vs SQL Server vNext
Henrico Bekker ...
It is an open secret that in SQL Server, we can "create a system object" by using an undocumented stored procedure sp_MS_marksystemobject as explained ...
In today's guest editorial: the motivation to do our best must come from within.
How to use the EXCEPT statement to perform row differences.
Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, ...
Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the excellent feedback ...
If you are introducing DevOps workflows into a large organization, you'll need to plan carefully and prioritize tasks, adapt, maintain a thick skin, ...
Hi expert, I have a issue when I restore database on sql server 2012 sometime. There is a database in server, I want to copy this database to same server ...
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you ask? Well, 4-5 system sessions were holding ...
In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL processes, reviewing best practices ...