(CliveW) Often for customer demos I show this particular example or get questions as its pinned to my Azure Dashboard – its the first thing you see.
Tag: sql server
Azure REST APIs with Postman in 2 Minutes
(Jon Gallant) The Azure REST APIs require a Bearer Token Authorization header. The docs do a great job explaining every authentication requirement, but do not tell you how to quickly get started. This post will hopefully solve that for you.
Closing all of the connections to a database
(Kenneth Fisher) Doing a database restore may not be the most common task a database professional will ever do, but it’s a lot more frequent than you might think. Operational restores are not exactly uncommon for example.
What’s In Your Database?
(Thomas LaRock) Recently, while settling in to watch television with my family, we were treated to an amusing advertisement for a credit card company. This particular commercial showed men dressed as Vikings asking questions about the contents of my wallet.
How to Turn on Instant File Initialization
(Greg Larsen) Do you have instant file initialization turned on? If you do, then allocating your database data pages will go much faster.
Debugging Azure Data Lake Job Failures Made Easy (part 1) – Debug U-SQL job failure of C# custom code
(Yanan Cai) Working with large datasets is hard — when developers build big data applications, it is impossible to cover the wide variety of input data as test cases. Untested or corrupt data often exposes corner cases in the user code as big data jobs get run at scale.
Graph database implementation with Azure Cosmos DB using the API
(Prashanth Jayaram) In my previous article, I’ve discussed a lot about the Graph database implementation with SQL Server 2017. In this case, we’ll see a walk-through of Graph API integration with Azure Cosmos DB.
SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298
(Pinal Dave) Due to development challenge people still use SQL 2012 in production. In one of the case a client told me that their application vendor has not approved SQL 2014 and above, so they were forced to install SQL 2012.
How to visualize multivariate relationships using Power BI
(Siddharth Mehta) SQL Server 2017 Machine Learning Services is set to bring machine learning capabilities to SQL Server with the integration of R and Python in SQL Server. Data exploration is a key and primary step of machine learning which requires analyzing how different attributes (also called va
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’
(Pinal Dave) Due to my connect with my many clients, learning never stops for me. Almost every day someone sends me email for quick 55 minute consultation. You can read more about it over here about how to fix error related to SQL Catalog.
