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

Building Your Brand

Today we have a guest editorial from Grant Fritchey as Steve is away on his sabbatical.

One way to begin to take your career to a new level is to publish online what you know, what you’re learning, and all the cool things you do. This may be blogging, recording videos, tweeting, Instagram, who knows. The sky is the limit when it comes to all the various types of social media and the means of sharing information online. Yet, building an online persona from scratch is a lot more difficult than it looks like from the inside.

I’ve been building out my persona since 2008. Actually, it started even earlier when I began writing articles for various web sites before finding a home at SQL Server Central. Things slowly expanded, and I started Tweeting. I set up a Facebook page. I started coordinating and automating all of that stuff together. Now, I have a unified online message, but it grew over the years.

Now, I’m just starting to help my local ham radio group set up its social media presence as a way to promote the organization and ham radio better. You know what, it’s a daunting task doing this for the first time. Suddenly, I can see why so many people just don’t bother. It’s a crazy amount of work to get all the different social media configured, with a common message, a common image. This is not easy.

So, here’s my advice to you. If you’re considering this, take it one step at a time. If you want to get a full-blown online persona, you can get there. However, it’s going to be work. Further, it’s going to be work you do in the evenings, on weekends, after you put the kids to bed or deal with that production outage. Don’t get discouraged. Don’t give up. Just take one step at a time. Know that getting yourself out there is worth the time and effort that it takes.

Grant Fritchey

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

Redgate Database Devops
 
  Featured Contents

Month-over-Month calculation using DAX in Power BI

aveek22 from SQLServerCentral

Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing, so the same amount of time has passed in the two […]

But the Database Worked in Development! Preventing Broken Constraints

Additional Articles from SimpleTalk

Database table constraints such as foreign keys and default values ensure reliability of the data. In this article, Phil Factor demonstrates a way to find any data that breaks the build so it can be corrected before deployment.

Basic Concepts of Probability Explained with Examples in SQL Server and R

Additional Articles from MSSQLTips.com

Many organizations have known the fact that data have been evolved from the by-product of corporate applications into a strategic asset [1]. Like other corporate assets, the asset requires specialized skills to maintain and analyze. With modern data analytic tools, for example Python, R, SAS and SPSS, IT professionals can build models and uncover previous unknown knowledge from the ocean of data.

From the SQL Server Central Blogs - In Memory Table Indexes

SQLEspresso from SQLEspresso

Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s look at indexes and how they are created and how they work within those tables....

From the SQL Server Central Blogs - Author of the Year 2019 Nomination at MSSQLTips

Koen Verbeeck from Koen Verbeeck

This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...

 

  Question of the Day

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

 

Auto Rounding

I have this code:
DECLARE @9s DECIMAL(38,12) = 0.9999999;
SELECT @9s*@9S;
GO
DECLARE @9s DECIMAL(20,12) = 0.9999999;
SELECT @9s*@9S;
GO
What results do I get back when I run this?

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)

SQLCMD Variables

I am writing a SQLCMD script in SSMS with SQLCMD mode. I want to set a variable in the script. How do I do this?

Answer: Use ":setvar" to start the line. Then put the variable name, a space, and the value.

Explanation: The format for a variable is:

:setvar varname value

Ref: Edit SQLCMD Scripts with Query Editor - https://docs.microsoft.com/en-us/sql/ssms/scripting/edit-sqlcmd-scripts-with-query-editor?view=sql-server-ver15

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
Error switch partition - hello Good morning all I want to switch the partition from one table to another I have this error message on a blocking because of the index   ALTER TABLE sales.SalesOrderDetail SWITCH PARTITION 1 TO sales.SalesOrderDetail_2014 PARTITION 1;   Warning: the partition specified 1 for the table 'produit.sales.SalesOrderDetail_2014' was ignored in the ALTER TABLE SWITCH […]
SQL Server 2017 - Development
BULK insert several thousand files - I have a bunch of logging data that my sysadmin has downloaded from our elastic load balancers at amazon and I need to stick it in a completely bland table for a one off sales pitch. I've scripted up all of the unzip, copy, etc etc…  but I've become so reliant on SSIS that I've […]
SQL Server 2016 - Administration
upgrade plan common sense check please - Be grateful for a yay or nay on my plan: 4 nodes. 2012.  1 x AG.  FCI.  1 local sync. 2 remote async. Upgrade to 2016 on all, failing over as required, doing remotes, then local secondary, then primary. Reboot all.  Run checks DBCCs etc. Then upgrade to SP1 via the same method above. Would […]
SQL Patching implementation date - Hi I am looking at the script to get SQL Patching implementation date . Any script that I can execute using SSMS ? Thanks Your feedback is much appreciated    
SQL Server 2016 - Development and T-SQL
Execute business rule runtime - Hi I have set of hundreds of business rules that I need to executed based on certain criteria. Just for example If product =A -          Code > 5   (code should be greater then 5) -          Height > 10 -          Width >5 If product = B -          Height > 8 -          Width >7 I want to […]
Trigger for only updating specific column - Hi, using Merge I can sync table A with Table B at ROW level. However 'how to update only specific column instead of the whole row'? Sincerely!  
Count of Distinct Clients in a list, in groups - Hello all, I have a dataset of trip information (the majority of which I got from another awesome forum member not long ago) where I need to be able to get a distinct count of passengers in the groups when someone is onboard the vehicle.  This trip information shows when a vehicle is picking up […]
What could cause MS Access app as a front-end to SQL, periodically run slow? - We've got an old Microsoft Access pharmacy application which acts as a front-end to a SQL Server 2016 database. Periodically the application will just start running slowly. We're working on a modern replacement app, but that won't be available for months. In the meantime, what can we do about this application suddenly running slowly? Here's […]
Development - SQL Server 2014
Recover data log loss - Hi. I would like to know is it possible to recover data log table from SQL Server 2014 without backup file?
SQL 2012 - General
What is spinlock ALLOC_CACHES_HASH? - Hi, Queries are slow, cpu usage at 80%. ALLOC_CACHES_HASH backoffs start at same time as problems are seen in application. "CACHES" would point to memory, but no obvious shortage there. This document says "internal use only"... https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-spinlock-stats-transact-sql?view=sql-server-ver15&viewFallbackFrom=sql-server-previousversions What to check next? spinlock_name delta_spins delta_backoff delta_minuntes delta_spins_per_millisecond_per_CPU ALLOC_CACHES_HASH 72412901394 16796814 30156 100053 SOS_OBJECT_STORE 17456 1 30156 […]
SQL Server 2019 - Administration
TDE / SQL server Database / SSIS - Dear Everyone We have implemented a data warehouse on-premises using SQL server 2019 enterprise edition running on VM Ware. SSIS, Database Warehouse and SSAS all reside on different servers in the same VLAN and now I am working on implementing TDE on the servers but I wanted to know the following: Is TDE required for […]
SQL Server Licencing Question - This question is about SQL Server Licencing and licencing for Maximum Virtualisation. I'm curious about the licence position for this scenario. You have one Hyper-V host (HOST1) with say 48 cores all core licenced with Enterprise Core and covered by SA. You can run an unlimited number of VMs. You have a second Hyper-V host […]
SQL Server 2008 - General
Error converting data type varchar to float - All, I know this topic has been discussed numerous times and I tried all possible solutions but to no avail, so here I am. I have an app that stores values like this in a varchar(7) column called Utilization in a table called CC_Agent_State_Summary : 0.02% 16.2% 99.91% The app does nothing but store and display […]
Reporting Services
SSRS 2016 install on FCI with AAAG. - Appreciate advice here as I am slightly confused. I need to install SSRS 2016 on an existing 4 node, cluster with AAAG.  I don't particularly need HA here or DR.  I guess I may as well read from my local secondary server as best practice. How would you implement this install? As SSRS is not […]
Powershell
Remove comma inside of double quotes - I have a file comma delimited that has no header. How can I clean the extra comma inside of my double quotes? It sees that comma and adds and extra field to my output. This is a short example data, my file has 37 columns and have found it in 2 fields for now, but […]
 

 

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

 

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