Visualization is often the first step in analyzing data. Python makes visualization easy. In this article, Robert Sheldon demonstrates how to generate multiple charts from one dataset using Python with SQL Server Machine Learning Services.
2018-03-02
3,557 reads
Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to set your dashboards to a current period.
2018-03-01
3,692 reads
Koen Verbeeck looks at how to hide tables or columns in Analysis Services Tabular 2017 for certain users so they are not able to use them in reports or query them.
2018-03-01
2,612 reads
By default, SQL Server does not encrypt data in a SQL Server database in an encrypted format. When SQL Server 2008 was introduced, Microsoft implemented Transparent Data Encryption (TDE). When TDE is enabled on a database SQL Server will encrypt the database as data is written to the disk.
2018-02-28
2,572 reads
In this article, we will show how to create an ASDW in Bash using the Cloud Shell.
2018-02-27
363 reads
Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived as the Lone DBA for 56 database servers for over a decade. While many DBAs work on teams instead of alone, she has great advice for all.
2018-02-27
4,567 reads
How to configure multiple publishers and single subscriber replication?
2018-02-26
6,019 reads
Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.
2018-02-26
5,733 reads
Loops are common in application code, but set-based solutions are the way to go with SQL.
2018-02-23 (first published: 2015-12-29)
6,378 reads
You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.
2018-02-23
7,201 reads
If you've ever loaded a 2 GB CSV into pandas just to run a...
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers