(Siddharth Mehta) Data is not always in the exact desirable format from the source system. Modulating data in-flight during the import process, reduces the need to make modifications to the schema and/or data post import.
Tag: sql server
(NEERAJ Sharma) You might already seen plenty of articles on the same topic, but today we will see all this with simple explational and an example to understand what actually the SET STATISTICS IO ON tells us?
(Vitor Faria Tomaz) We have a good example on how to use C# to create an Azure SQL database with the Microsoft Azure SQL Management Library for .NET at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-get-started-csharp
SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
(Pinal Dave) A few months ago, I wrote a blog which tells us reasons about why we should use tools provided with the product rather than generic tools. Yeah, I am talking about services.msc vs. SQL Server Configuration manager.
(Chris Webb) One of the most confusing, under-documented and widely-misunderstood features of Power BI and Power Query (or Excel “Get & Transform” or whatever you want to call it) are the data privacy settings.
(Edward Elliott) To achieve gains from Database Lifecycle Management in general, and in Continuous Deployment in particular, it pays to aim for lightweight but consistent techniques and processes, refining them iteratively in the light of experience.
(Cate Murray) In our Job Search Strategies webcast, a question arose around getting a remote job. This is certainly a hot topic, as more and more employees want increased flexibility on where, when and they do their work. The specific question was “What recommendations do you have when applying for
(NEERAJ Sharma) Group By uses in SQL Server with select query to view column(s) as a group, only one row return for each group specified and if we want, we can perform aggregate functions for each group.
(NEERAJ Sharma) This article lays the foundations for my upcoming series on which we will learn why the clustered index should be Static, Unique, ever increasing and narrow. To understand and compare we are first creating an ideal primary key (Clustered Index) remember by default SQL Server create
(benjamin perkins) I wrote this article “Making changes to the applicationHost.config on Azure App Service” here which explains the details about creating an XDT file that supports the configuration of some properties found in the applicationHost.config file.