Aggregate Data for the Last Day of the Month
On some occasions you will need to aggregate Data for the Last Day of the Month. This article explains how.
2020-04-03 (first published: 2018-08-16)
3,344 reads
Articles
SQL Server and Undocumented Extended Procedures
Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented procedures for automating tasks, and that PowerShell may have what you need instead.
2020-04-03
Check Your Backup Compliance Against a Data Management Provider
As a database administrator, it's your responsibility to ensure the customer data won't get lost in case of a disaster, so you either provide your own backup strategy, use a third-party script, or hire a data management provider. With the first two options, you have full control over your environment so you can know exactly […]
2020-04-02
669 reads
How to Track Performance of Queries That Use RECOMPILE Hints
Say we have a stored procedure that has two queries in it, the first query will always get the same plan, but the second query will get different plans and return different numbers of rows depending on which reputation we pass in.
2020-04-02
SQL v.Next Gets Native Python in SQL Server
The next version of SQL Server is in early preview and there is a new feature that is going to be very useful for large enterprises that want to run Big Data Clusters and perform additional data science tasks. Instead of embedding Python code in a string and submitting it to the Launchpad engine, we […]
2020-04-01
3,603 reads
“Working” From Home? Watch A Bunch of Free SQL Server Videos on YouTube.
You’re new at this working from home thing, and you’re trying to put Game of Thrones up on a second monitor while you work? Listen, that’s not gonna play out well. You’re gonna get distracted and you’re not gonna get any work done. Instead, if you’re gonna have something in the background, learn about SQL Server.
2020-04-01
Free eBook: SQL Server Transaction Log Management
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.
2020-04-01 (first published: 2013-08-14)
104,952 reads
Never Create Columns with ANSI_PADDING set to OFF
There is no good reason for having ANSI_PADDING set to OFF when you create tables in SQL Server. It was provided purely for legacy databases that had code that assumed the old CHAR behavior for dealing with padding, and its use has now been deprecated.
2020-04-01
1,325 reads
Graphical analysis of SSRS report usage with Grafana
Learn how Grafana can help you quickly set up dashboards to analyze the usage data of your SSRS reports.
2020-03-31
3,330 reads
Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script
Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing.
2020-03-31
Blogs
Covid Thoughts, So Far
By Andy Warren
I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...
How to Think Like a Certification Exam at the PASS Professional Development Virtual Group
By Will Assaf
Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...
Deploy BACPAC to Azure Managed Instance failing from SSMS?
By Daniel Janik
Recently I ran into an error when trying to copy a small database bacpac...
Forums
Buy Real registered Passport, Visa, drivers license, ID cards, IELTS whatsapp..
We are experts with many years of experience in the production of Database passports,...
Advantages and Disadvantage using Temp Table or Fisical Table
Please share your thought about advantages and disadvantages for processing using temp table or...
Do people process data from beginning of time when there is data change?
This might be a beginner developer questions but need some clarifications. What is best...
Ask SSC