(Krishnakumar Rukmangathan) Analysis Services model can be deployed in Azure in different ways like from SSDT or by running the JSON create script from SSMS.
Tag: sql server
(Scott Murray) What Power BI features are available to notify a report consumer of data changes?
(Pinal Dave) The other day while working with a customer during SQL Server Performance Tuning Practical Workshop, I noticed an MDF file with very strange extensions. When I asked the DBA why they have such a large data file with extension PDF (instead of common MDF file extension), he replied that h
(Sergey Gigoyan) Did you ever have a problem handling SQL Server transactions in nested stored procedures? Did you ever receive an error message “Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.”?
(James Serra) Many product announcements were made this week at Microsoft Ignite, and I wanted to give a quick overview of all the data platform related announcements:
(Grant Fritchey) If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and a database with a table in it. You may have more if you’ve been practicing.
(Pinal Dave) SQL Server Management Studio (SSMS) has been removed from the product release cycle. Now SSMS is shipped as a free tool and doesn’t need to have set up media to install. Earlier I wrote a blog which you can read below.
(Hannes du Preez) The following code enables you to identify all of your foreign keys in a particular database.
(Chris Webb) I’ve blogged a few times about the tracing functionality that is built into Power Query/Get&Transform and Power BI (see here and here). The trace files themselves clearly contain a lot of interesting information, but there’s no official documentation about what they contain and the form
(Slava Oks) It has taken us a little more than two and a half years to bring an official version of SQL Server to Linux. Over the course of our work, we encountered many supporters, bystanders, skeptics, and pessimists.