Check our Tip of the Week, about the main technical characteristics of CosmosDB. Tip of the Week #5 The main technical characteristics of Azure Cosmos DB are: Ability to globally distribute your data Multiple data models and APIs for working with your data You can elastically and independently scale throughput and storage on demand … Read more…
This is a quick but useful tip, on how to change the font and size of Grid or Text Results in SSMS. For changing the font and/or size of Grid results in SQL Server Management Studio (SSMS): Within SSMS, navigate to the “Tools” menu, then “Options”, “Fonts and Colors” and select to “Show settings … Read more…
In different cases in our everyday life, among other, we face different technical challenges. These challenges, might have to do with a task we are trying to perform at work, an error we get on our smartphone, etc. In this single post, I will be providing short solutions and tips, to different technical challenges I … Read more…
Check our Tip of the Week, about JSON support in SQL Server. Tip of the Week #4 Stretch Database in SQL Server 2016 and later, allows storing historical data in the Microsoft Azure cloud. It runs in the background and provides seamless access to both local and remote data. Among other, it can be … Read more…
Check our Tip of the Week, about JSON support in SQL Server. Tip of the Week #3 Since SQL Server 2016 and later, TempDB system database can be configured via SQL Server 2016 installation wizard. For example, you can set the number of data files and growth settings, as well as set multiple volumes … Read more…
Check our Tip of the Week, about JSON support in SQL Server. Tip of the Week #2 With JSON support in SQL Server 2016 and later, you can format query results as JSON by adding the FOR JSON clause to a SELECT statement in SQL Server. Also, you can convert JSON data to rows … Read more…
Check our Tip of the Week, about the SQL Server Always Encrypted feature! Tip of the Week #1 With Always Encrypted in SQL Server 2016 and later, you can protect sensitive data, by encrypting sensitive data on the application side, without revealing the encryption keys to the Database Engine. To this end, through a … Read more…
Hi friends around the globe! We are pleased to announce a brand new blog post series titled “Tip of the Week“. Via this series, every Monday, we will be sharing with you, useful short tips on a variety of topics such as: SQL Server Administration and Development, Azure SQL Database, Programming, Data Access and more! … Read more…
Hi friends! Today we announce another new free online service just for you, the SQL Server Community! This new service is titled “SQL Server OS Requirements Info“, and as the name implies, by using this service, you can quickly retrieve useful information, about the OS requirements for any version and edition of SQL Server! You … Read more…
In this article, you will learn what Entity Framework Core is and how to enable it in your C# Projects in Visual Studio. Entity Framework Core, is the Cross-Platform version of ADO .NET Entity Framework. In one of my older articles, I have provided an introduction to Entity Framework. Entity Framework Core, as mentioned above, is its … Read more…
In this article, we will talk about temporary tables in SQL Server and more specifically, we will answer the question: What are Local and Global Temporary Tables in SQL Server? What are Temporary Tables in SQL Server? Temporary tables in SQL Server, is a special type of database tables which once created, exist only … Read more…
In this article, in our “Beginners Corners” series of articles, you will learn what are Relational Database Management Systems (DBMSs) and the SQL Server Data Platform. What are Relational Database Management Systems (RDBMs)? Relational Database Management Systems, also abbreviated as RDBMSs, are systems which are based on the relational model of data. The approach … Read more…
In this article, we will talk about SQL Server Express Edition, its characteristics and limitations, and how you can download it and install it on a new Windows environment, along with installing the latest version of SQL Server Management Studio (SSMS). What is SQL Server Express Edition? SQL Server Express Edition, is a special, … Read more…
Hi friends. Finally, after months of hard work, I’m proudly announcing the release of my new online course, titled: “Essential SQL Server Development Tips for SQL Developers“. In this course, via a combination of lectures, downloadable resources and over than 30 live demos/hands-on guides, you will learn many useful SQL Server database programming hands-on tips, … Read more…
This post provides a fix suggestion for the error message “VS Shell Installation has Failed with Exit Code 1638“, when trying to install SQL Server 2016 features on a Windows Server. When you Might Get this Error? You might get the “VS Shell Installation has Failed with Exit Code 1638” error message when trying … Read more…