Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate SQL Source Control
The Voice of the DBA
 

Updating Certifications

When I first started my career, certifications were hot. I worked on the Netware CNE and Microsoft MCSE certs. Nearly 30 years ago these certifications were controversial as plenty of awardees weren't competent at their jobs in the real world. However, marketing worked and employers wanted these certs, so they mattered.

Over the years I've worked on books for a few certifications and taken a number of tests. Partially as research and partially to test myself. I've personally found the certifications to be helpful because they focus my efforts in learning about a technology. I've found them to be maddening at times because the questions haven't always felt very applicable to the world.

That being said, since I write many of the daily QotD questions, and regularly get complaints on my work, I appreciate how hard it is to write good questions that relate to the real world.

In any case, I never pursued the MCSA, MCDBA, or MCSD, and I'm somewhat glad I didn't decide to start. Microsoft is retiring these broad, general certs as of June 30, 2020. If you are working on one of these, you have until then to pass exams. After that, you can't earn one of these certs.

Microsoft isn't abandoning certs, but moving to role based certs. These should be more granular in nature, focusing on the things you might do for a job. Of course, some of these are retiring on Apr 2, so it's a bit of a mess right now.

The part that many people might not like about this is that these certs are all Azure based. I think that upsets some people, especially those that only deal with SQL Server on-premises. I think that's fair, though I do think that most of the skills relate to both, after all, they do have a common code base. Azure doesn't always mean PaaS, and the IaaS offerings with SQL Server are going to be what you get when you install the software on your own hardware.

I'm not going to advocate for or against certifications. Like any training or educational achievement, a lot of the value is based on what effort you expended and how you present your work. If you want to earn an older cert, you need to hurry. If you're looking for a new one that helps you stand out from others, you have some options. If you're interested in pursuing a certification, let us know today.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

Redgate SQL Source Control
 
 Featured Contents

Approaches to Import JSON in SSIS (SQL Server 2016+) Part 1

Nikolai Basov from SQLServerCentral.com

In this article, 1st of 2-part series, we will look at 2 approaches to import JSON in SSIS using 2 methods: the new functionality of SQL Server 2016 and the Json.NET library.

Free Fundamentals of Index Tuning Week: Part 2, Indexing for ORDER BY

Additional Articles from Brent Ozar Unlimited Blog

I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class. To make that easier, I’m running the Fundamentals of Index Tuning class this week on the blog.

From the SQL Server Central Blogs - Change the size of the grid results view in SSMS

Kenneth.Fisher from SQLStudies

After my post last month about configuring your tools I’ve been on a make my life easier kick and one ... Continue reading

From the SQL Server Central Blogs - Women’s History Month and Being Better

Steve Jones - SSC Editor from The Voice of the DBA

This month is Women’s History Month, and it’s a chance to stop and think about the impact that women have had in history. After reading Monica Rathbun’s post on...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

The SQLCMD GO

I am writing a SQLCMD script in SSMS with SQLCMD mode. I need to have a batch separator in my script, and am planning to use GO. What options do I have for the batch separator on it's own line?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Memory Optimized Table Limitations

In SQL Server 2017, what are the restrictions for Memory-Optimized Tables (MOT) and Foreign Keys (FK)?

Answer: MOT tables can only have FKs to other MOT table PKs

Explanation: The MOT tables can only have FKs to other MOT tables. These would be to a PK in an MOT table. You cannot have a FK to a regular user table. Ref:

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2017 - Administration
SQL Replication issue when trying to add Subscriber through SQL job - I'm using SQL 2017 ( Developer Edition), our environment has a requirement of setting up the replication weekly. (Because we had to reload the database back to an older version). I've setup the transactional replication with initialize with backups option and I'm trying set them all up with SQL agent jobs. My setup and scripts […]
Firewall in SQL - Hi team There is an argument in our company, that we have a perimeter firewall between the SQL DB infrastructure and Internet, but there is no firewall between the (DB) server and the client. So the reason I am writing this, is to understand  how as a DBA we can be responsible to secure and […]
SQL Server 2017 - Development
Report - I never created SSIS from SQL query output I need to send email to end User either in Excel or Text format. How can I do in SQL or it has to be done via SSIs?
get rid of key lookup - trying to help 3rd party app (can't fix tsql) with an index big tie up on key lookups, made covering index still won't use it  
Automate Log Full Issue - Hello Everyone, I am new to develop queries and planning to automate Log Full issues fix using stored procedure and trying to develop the SP. Could you please help me to complete it. Below query is not working if log_reuse_wait_desc is due to LOG_BACKUP and getting the error : Error converting data type nvarchar to […]
SQL Server 2016 - Administration
Restoring file group from one database to another - Hello, I am doing some testing and looking at Filegroup articles, specifically: Database Filegroup(s) and Piecemeal restores in SQL Server Piecemeal restore. but I am wondering if I can apply the filegroup backup from one database to another, specifically restoring only a particular filegroup of the database, and not have to backup the entire database, […]
SQL Server 2016 - Development and T-SQL
Inserting large data volumes into a table as fast as possible - I'm doing development on large SCD2 tables (100M+ rows).  When I've fixed bugs and it's time to re-run, I need to restore the data back to a known point, currently via truncate and insert from a backup table. This process is taking FOREVER and slowing down my development. Sample code to restore the tables: /* […]
Could you list db modeling tools you use on daily basis? - Hi, while looking for new position I see beside  DBA and SQL skills(SSRS, SSIS, Powershell ..) company  adding "database design/modeling " Question: What tools currently   you use on daily basis   for physical and  logic  database modeling I used to model in Erwin, but might be the is new  less costly and more simple tools  […]
Administration - SQL Server 2014
Compat Level change and Impact on Query Performance - Hello DBA Gurus, We have a prod SQL Server Instance with a critical Database  on SQL Server 2014, but Compat Level  on SQL Server 2012 ( Compat Level 110) . It was probably set in that level, way back by someone so the workloads, queries etc can be tested.One morning there were performance issues  on […]
Limited SSMS - Basic tool - Hi,   Some of our users have the need to run queries against production DB's. They are light SQL users - meaning they need to run light queries against production occasionally. I do not really want to give them SSMS with READ only access to production - because they could still easily write a query […]
SQL 2012 - General
can I kill a spid executing a delete or update or insert statement - when I check the deadlock in the database, there are some deadlocks caused by the delete or update  or insert sql statement, if I kill the spid  which executing delete or update  or insert sql statement, does it make data loss or data wrong or data inconsistency ? thanks!      
SQL Server 2012 - T-SQL
Query not contained in either an aggregate function or the GROUP BY clause. - Msg 8120, Level 16, State 1, Line 2 Column 'TimeReporting.dbo.TimeData.ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Query Here: SELECT ID, EmpNo, Date1, SUM(Time1) FROM [TimeReporting].[dbo].[TimeData] WHERE Date1 BETWEEN '2020-03-01' AND '2020-03-08' AND EmpNo = '8939' Table Here: ID bigint Unchecked […]
SQL Server 2019 - Administration
Memory Management - Hello DB Gurus, We have about 700 databases on a production SQL Server instance, some are small but they consume memory . Host has 96 GB, SQL Server has 75 GB and I see over all Memory Utilization 90%.  What are the steps to reduce  / watch SQL Server Memory. I know once the Memory […]
SQL Server 2019 - Development
SQL query - Build Schema script provided. for each student , need to print if he missed any pre-requisites, plus the current application course from the application table . it should not print any course already registered in register table. . Expected result given inside the script. Scripts: create table applications ( student_id INT, requested_course VARCHAR(4) ) ; […]
Integration Services
Changing ScriptLanguage to Microsoft Visual C# 2017 - Hello I'm just wondering how this works   I have a package that I've upgraded from 2008 by adding it to a brand new project and following the upgrade path This seems to work fine One thing I have noticed is that the scripts all convert to Microsft Visual C# 2015 (I either edit script […]
 

 

RSS FeedTwitter

This email has been sent to {email}. 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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -