Sites anglophones


How to Generate Random Password in SQL Server? – Interview Question of the Week #181

Publié le 8 juillet 2018 sur journey to sqlauthority
 

Question: How to Generate Random Password in SQL Server? Answer: This is a fantastic question and here is the script to generate a random password in SQL Server DECLARE @char CHAR =  » DECLARE @charI INT = 0 DECLARE @password VARCHAR(100) =  » DEC …

SQL SERVER Analysis Services – Unable to Start Service. Error: The Filename, Directory Name, or Volume Label Syntax is Incorrect

Publié le 7 juillet 2018 sur journey to sqlauthority
 

Sometimes I get a chance to work on something which I have not worked earlier but I give my 100% before I give up. This gives me chance to learn something new and every time I get a new topic to write a blog. In this blog, we would learn about fixing …

Why SQL Developers Keep Making The Same Mistakes

Publié le 6 juillet 2018 sur brentozar.com
 

Dead Horses I read a lot of SQL blogs, both new and old. What’s striking is how many blogs seem to cover the same subjects from different angles, over and over again. This isn’t to knock anyone’s blogging at all — but what I do …

Traditional database security doesn’t protect data

Publié le 6 juillet 2018 sur sqlservercentral.com
 

Alex Yates proposes that the features we think of as traditional database security are not sufficient to protect your data. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by …

Auto-suggesting foreign keys and data model archaeology

Publié le 6 juillet 2018 sur sqlservercentral.com
 

If you can understand the data model then you can understand the intent of the application developers.

SQL SERVER – Backup to Microsoft Azure Tool – ERROR: Account Verification Failed

Publié le 6 juillet 2018 sur journey to sqlauthority
 

I have been seeing many customers moving their SQL Server to Cloud. Few of them have chosen Microsoft Azure platform to host their production server and few others have selected other cloud platforms like AWS. When they host SQL in Azure, they can choo …

SQL Server Diagnostic Information Queries for July 2018

Publié le 5 juillet 2018 sur sqlskills.com - glen berry
 

This month, there are improvements to seven of the the SQL Server 2012 and newer versions of the queries, with a new column that shows whether there is a missing index warning in the cached query plan. A reader named Håkan Winther made this usefu …

Ola Hallengren’s Scripts Keep Getting Better

Publié le 5 juillet 2018 sur brentozar.com
 

You Know Him, You Love Him You trust your database backups and integrity checks to him, and he has been KILLING IT on new features lately. A while back, Ola decided to Open Source his scripts on GitHub (Soon to be known as Microsoft LiveHub for Busines …

Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4

Publié le 5 juillet 2018 sur simple-talk.com
 

The series so far: Power BI Introduction: Tour of Power BI — Part 1 Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 Power BI Introduction: Workin …

Using Parameters for SQL Server Queries and Stored Procedures

Publié le 5 juillet 2018 sur sqlservercentral.com
 

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this …

Creating Compound Interest Calculations in SQL

Publié le 5 juillet 2018 sur sqlservercentral.com
 

This is the first article in a short series of SQL Server query challenges to test and expand your SQL Server querying skills

SQL SERVER – Unable to See SQL Server Configuration Manager. How to Open it?

Publié le 5 juillet 2018 sur journey to sqlauthority
 

I get many emails every day and I do respond to them as soon as I can.  Sometimes they are about the business and sometimes they are from my blog readers who have followed my other blog and need help with something else. Most of the time, I do hav …

10 SQL Server Feature Requests I’ve Upvoted Recently

Publié le 4 juillet 2018 sur brentozar.com
 

In no particular order: Database Level Option for Storing Wait Stats – just like we can store query plan history in Query Store, it’d be awesome to get performance history over time. Give more info on the “String or Binary Data Would …

SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client Was Not Authenticated. The Server Response Was: 5.5.1 – Using Gmail

Publié le 4 juillet 2018 sur journey to sqlauthority
 

In my earlier blog, we saw one possible cause database mail error due to SSL settings. Today we will learn about another Database Mail Error. SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client was not Aut …

Management Studio Hides Missing Indexes From You.

Publié le 3 juillet 2018 sur brentozar.com
 

SQL Server Management Studio only shows you the first missing index recommendation in a plan. Not the best one. Not all of them. Just whichever one happens to show up first. Using the public Stack Overflow database, I’ll run a simple query:S …


Pages :