 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | Fundamentals Volleyball season is approaching. Practice started last week for the team that I'm coaching this year, and I'm excited. I look forward to teaching and competing with a new group of athletes each year. I'll also look forward to a more regular schedule and a bit less traveling for a few months. In preparation for this season, I've been doing some learning, some reading and watching, trying to improve my abilities, something I've done for a few years. One of the books I completed recently was one on John Wooden and called Wooden: A Coaches Life. This was a look at his life, as player and coach, with some of the descriptions and principles that embodied his work as a college basketball coach. There were interesting stories and topics in the book, but one of the core items emphasized in the book was Coach Wooden's emphasis on the fundamentals of the game. He stressed this with his players, asking them to work on the basics and perfect them more than on any complex plays or situations. I tend to focus on the basics when I coach as well, hoping to train players to be good at their jobs, trusting them to react to new situations. This feels like advice that is applicable to a data professional as well, especially in the era of new features and functions that continually expand on the capabilities of the Microsoft data platform. While graph structures and containers and Azure Data Factory and Big Data Clusters are amazing new technologies, there is still a need to have good, solid fundamental skills for a SQL Server system. We still expect anyone working in those areas knows how to backup a database, how to write good T-SQL, how to set security for objects, and more. If you want to specialize, that's great. Perhaps you love BI or HA or some other aspect of working with the SQL Server data platform. Just keep in mind that the fundamentals are important, no matter what your job. You ought to be very competent at handling any of those tasks that we would teach a junior DBA in their first year on the job. Once you know those, you can move on to more specific items. If you don't know those, be sure you include those as part of your learning along with more niche topics. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.4MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control.
Try it free |
|  | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
|
|
|
| | |
 | Press Release from Redgate Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from 15% in 2017. And Redgate is acknowledged in the Guide as a representative vendor for Data Masking. More » |
 | Additional Articles from Database Journal Azure SQL Database offers a straightforward approach to controlling its performance through vertical scaling. Despite its simplicity, scaling up has obvious pricing implications and, while it is an online operation, it might result in rollback of in-flight transactions. If you are looking for a supplemental approach to enhancing performance, then you might want to consider implementing in-memory technologies which are part of the Azure SQL Database feature set. More » |
 | SQLEspresso from SQLServerCentral Blogs Did you know compression can gain you more than just space on a disk, it can allow you to fit... More » |
| | Justin Figg from SQLServerCentral Blogs Creating a table to be in memory compared to standard tables that use the files on disk can have several... More » |
|
|
| | | Today's Question (by Steve Jones): I created and endpoint for my Availability Group that is owned by me, Steve. I don't want that dependency as I may get a new job, so I want to change the endpoint owner to sa. The endpoint is called ag_endpoint. What code do I run to change the owner? |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: always on. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| | |
| | | Michael D'Spain from SQLServerCentral.com A customer had an issue where quoted_identifiers was being turned off for random SPs. My task wasn't to find out why that was happening but to find a way to script out the SPs and replace the proper text and alter the procedures as it was causing an outage. This script is intended to be run by the customer and on a box with the sqlps module. Call the script from powershell proper or open the script in Powershell ISE and execute. The script will ask you for a DB instance name. Progress wil be written to the screen. Hope you find this useful. Michael D'Spain http://thesurfingdba.weebly.com More »
|
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
Help with script. - Please forgive me if im in the wrong area. New To SQL. I have 2 SQL statements but i need to... Error while restoring a database from a backup - I am trying to restore a database from a backup (.bak) file which is in shared folder where the instance...
Query first 2 results based on age and description - Guys, Is there a way to do the following. Temp data and expected results included: The oldest 2 results based on... Struggling with formatting decimal numbers and padding them with zeros to be saved in the char fields - I am preparing data for being output to text file via ssis in a certain format required by the receiving... When is DECLARE absolutely required? - After the CREATE PROCEDURE line, the next line defines a parameter variable. Why isn't the DECLARE keyword used here? Starting... trying to avoid the Arithmetic Overflow error - How can I convert the number to DECIMAL (4,1) and then back to varchar (this is a varchar (40) column... Column names on INNER JOINS - In my code below I have Invoices.InvID Insert Date from integer month and year columns in the same table - Hi, Please consider the following tables. Invoices are issued when products are sent to customer. for each customer could be one...
Composite indexes; performance - Hi everybody, I have couple quick questions for the DBAs. We have 2 heavy SELECT statements in 2 stored procedures, that are...
Looking for a SQL Statement to populate the TOTAL row in this SQL Server table - This is the actual SQL table, imported into Excel. The attached Excel file shows that I need to fill the... Julian Date - I have a table called ORDER with columns OrderDate and OrderTime both are in Julian Date format. I'm trying to... Execute a Stored Procedure against every row insert in Table - I have around 200 tables and we have insert in each table with in each seconds. so there are around 90... Index statistic is empty - how is this possible? - I have a simple index on a table - just one column in the index plus one included column. There is...
Select only one register with condition - Hi Guys, I need a help for a query development that returns only one record according to the condition. But if...
How to Become a MCDBA ? - Hi All, How to become a MCDBA certified, Which exam i need to pass ? Thanks & Regards Deepak
How do you change the Text Legend to BOLD just for the total in the SRSS report? - In my Series Group, I have the Label with the following expression: =(Fields!School.Value) & (COUNT(Fields!School.Value, "Chart3_SeriesGroup")) want to make the COUNT part appear...
Converting between binary hex and GUID (uniqueidentifier) - Sounds easy. but I'm trying to connect the field in msdb.dbo.sysjob (uniqueidentifier) to the text based binary version in...
Replacing string in text file with another string - I need to replace all occurrences of 'ABCD' in .txt file with 'EFGH'. Is it possible to do from an SSIS...
Problem using expression in SSIS - Hi, Below is the expression i am trying to make work : substring ("Archive_Full_20120731200002",1, (FINDSTRING( "Archive_Full_20120731200002","Full_", 1)-2)) Whe I use the exact string(Archive_Full_20120731200002)...
SELECT TOP 1 on Primary Key? - I have a table (let's call it TableA) with a primary key defined (let's say the column is called ColumnPrimary).... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
