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

Daily Coping Tip

Make a list of three things that you can feel hopeful about

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

The Computing Revolution

One of the keynotes at this year's Build conference was on the Future of Tech. This was a mix of live talk and recorded pieces from Kevin Scott, CTO at Microsoft. This talk looks at the innovation of tech, with lots of AI/ML, but also with the idea that data is fundamental to the future. While he notes that there are different eras in computing as we have breakthroughs, one of the fundamental things that will change the world is the data explosion.

We constantly push through boundaries and past constraints that limited us just a few years ago. I can still remember a professor in college bragging about the 32MB of RAM in his Solaris workstation, at a time when many of us had 1,2, or maybe 4MB. I think about that each time I get a new device. In a generation of my life, we've grown an order of magnitude, and pushed into a new world where I don't have an exponential level of computing on my desk, but in my pocket.

We might appreciate or worry about the growth of data, and it's implications, or we may get excited and embrace it. Either way, big data is coming, and it continues to come to many organizations. While most of us aren't pushing 10TB+ databases, some of us are, and few of us think in MB anymore. Makes you think that perhaps the default settings in SQL Server for MB in some cases are silly. Surely a MB is a like a penny (or pence in the UK), take one, leave one, but they don't really count. Not until there are hundreds of them, and even then, maybe only a thousand is worth much mental effort.

I do agree that the big win with the Internet, and with many pieces of software, isn't the platform, but the ways in which people take advantage of the platform. I think that the creativity of developers, taking advantage of incredible computing on mobile, is what has created an amazing revolution. However, it's not really just the creative software, but the understanding and use of data at scale that has really enabled software to change the world. Access to lots of data, whether this is people wanting car rides, sharing their thoughts and images, or just the bits that make up the music of the world are the ways in which software can become incredibly popular. Also, this is how things might get incredibly dangerous.

I do think that AI has the chance to become an inflection point in computing, helping to create more applications that will work with humans in new ways that harness our knowledge, ethics, and vision with the computing power that continues to grow in incredible ways.

The keynote is an interesting watch. It's about 45 minutes, but if you want to dream a bit, it's worth your time.

Steve Jones - SSC Editor

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

 
 Featured Contents

SQL Server 2012 does not come up after service pack upgrade SP4

iLearnSQL from SQLServerCentral

A failed SQL Server Service Pack upgrade is fixed with a trace flag.

SQL Server TempDB Tutorial

Additional Articles from MSSQLTips.com

In this article we cover many different questions about the SQL Server TempDB database to give a better understanding of what is and what it is used for.

What specific deployment data is valuable to you or your organization?

Additional Articles from Redgate

Redgate have assembled a small development team to research and build a capability that not only records your deployments over time, but provides a window into past trends and insights. To achieve the best results we need to understand from you what deployment value should be recorded and displayed. Please help us by completing our short two-page survey.

From the SQL Server Central Blogs - SQL Server and Docker Compose

dbafromthecold@gmail.com from The DBA Who Came In From The Cold

I used to think that Docker Compose was used solely to spin up multiple containers, in fact I blogged about doing just that here. That opinion changed when I...

From the SQL Server Central Blogs - Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)

Kendra.Little from SQLServerCentral

I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.

In this episode I share...

 

 Question of the Day

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

 

The Binary Cast

What happens when I run this code?
SELECT CAST(0x7e AS NUMERIC(10,4))

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)

BDC Containers

What types of containers are supported in Big Data Clusters?

Answer: SQL Server, Spark, and HDFS containers

Explanation: A  BDC (Big Data Cluster) supports SQL Server, Spark, and HDFS containers. Ref: What are SQL Server Big Data Clusters? - https://docs.microsoft.com/en-us/sql/big-data-cluster/big-data-cluster-overview?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
Table Partition in Sql Server - Hi Team, we have a table like 1.5 tb in size and around 800 cr records. I would like to make it as partitioned table. to make partition we need to drop and recreate primary and FK constraints will take more time. we need to perform this on more tables. so is there any approach […]
SQL Server 2017 - Development
SQL Query Help - CHARINDEX - Need query help. create table #tblTest1 (ID int, SName varchar(50), Type varchar(10)) INSERT INTO #tblTest1 values (1,'abc/efg','OS') INSERT INTO #tblTest1 values (2,'xyz/tgf','OS') INSERT INTO #tblTest1 values (2,'tgf/xxx','OS') INSERT INTO #tblTest1 values (3,'ccc/ppp','OS') INSERT INTO #tblTest1 values (4,'ddd/tqm','OS') INSERT INTO #tblTest1 values (5,'mpg/eee','OS') create table #tblTest2 (SName varchar(50)) INSERT INTO #tblTest2 values ('efg') INSERT INTO #tblTest2 […]
SQL Server 2016 - Administration
Merge replication can't update trigger at subscriber Msg 21531, Level 16, State - I have a trigger (merge replication) at a subscriber that does not match what is on the publisher. Publisher is correct and I need to get this pushed to the subscriber. When I update the trigger on the publisher query reports successful. Looking at SSMS Profiler I see calls to sys.sp_MSmerge_ddldispatcher but trigger is not […]
SCOM alert offline/recovery pending/suspect... but DBs seems fine - Hello experts, We are using SCOM to monitor SQL Server AOAG, and I am having trouble resolving this alert: Database is in offline/recovery pending/suspect/emergency state I use the alert details to check the status of the databases on each of the AOAG replicas, as well as the Always On High Availability Dashboard. The dashboard is […]
What Should be...? - Dear friends, Using Always On in our corporate site, we have 3 nodes deployed, our main database backup is based on images of that virtual  machines, but constantly I have databases requesting transaction log backups, what role should have a normal backup of transaction log files vs virtual machines images backup, our management team has […]
Cannot connect after Availability Group automatic failover - Hi We have a SQL Server setup with Availaibility Groups, in the cluster we have four nodes, two in one datacenter and two in another datacenter. There are four AGs on these cluster nodes, each primarially on one of the four nodes, with one other node in the same datacenter for syncronous HA and the […]
SQL Server 2016 - Development and T-SQL
How to grant only read(Select) permissions to the Group of Users - I have a business requirement where Business Users are all available in Group "TradingBusinessUsers" , Now i want to grant select permissions to all tables for the users in the group "TradingBusinessUsers"  and also users are allowed to create table on their own Self-schema and manage their tables. Can anyone help me to solve this […]
Is it possible to display Date in between in cube without multiplying the Data? - Ahoi, I have to display "discount" as a measure in my Cube. The basic structure is: DateFrom DateUntill DiscountMeasure   The request is: Have a Date and display the DiscountMeasure. My question is: Is there a better way to solve this than creating a dataset for each day between DateFrom and DateUntill? I was hoping […]
SQL Server 2012 - T-SQL
Need help formatting BCP output - Hello, I have a bcp script that generates stored procedure code output as shown below. bcp "select RTRIM(LTRIM(c.text)) FROM sys.objects AS o INNER JOIN sys.syscomments AS c ON o.object_id = c.id WHERE o.type = 'P' AND o.name = 'sp_ic9av0_dx_length'" queryout "\\dbserver1\j$\Backup\NG Sps\sp_ic9av0_dx_length.sql" -t -c -r "\t" -SServer1 -T -dMyDb There is a formatting issue in […]
SQL Server 2019 - Administration
Update - I have a Use case like. We migrated around 1000 millions of rows into around 5-6 tables. client requirement frequently change to update some columns. Is there any best way to Update those tables other then Batch/looping updates. We tried disabling all the index but still it's taking too much time. Even we have 5-8 […]
Page File. Set Value, or let Windows Manage it ? - I friend at another company said they got an out of memory error on their Production SQL server. It has 24 Gig of RAM and a 4 Gig page file. Their hosting company said they can increase the page file to a set value, or let Windows manage it. If Windows manages it, is there […]
SQL Server Hardware Recommendation - Hi,   I'm looking for a recommended Hardware Spec to run SQL Server 2019 Enterprise on. Our software vendor has suggested the below, but was looking for other people's thoughts. Our Database is currently sitting on a SQL2000 database - it's around 300GB in size and is accessed by around 90 people at a time. […]
SQL Server 2019 - Development
DateDiff for only @p_start_date and @p_enddate - So I am trying to get the datediff for parameters selected, even though the 2 dates could span 60 days, for an example I have 2 dates available(2018-01-05 11:08:00) and unavailable (2017-10-30 05:05:00) I only want the datediff where @p_start_date = 2017-12-01 and @p_end_date = 2017-12-31 those are the selected parameters.
SQL Collation to match IBMi - In SQL, these items sort this way INV175 INV190 INVB03 INVB04 On the IBM iSeries, they sort. INVB03 INVB04 INV175 INV190 Is there a SQL Collation I can use in a query to make a SQL Select ORDER BY match the IBM Sort ?   EDIT: I found this in an old post, which seems […]
Integration Services
Access Files Stored in Box.com - Has anyone created an SSIS package which grabs data from one or more files stored on Box.com? I would be interested in hearing how you got on. Did you get the Box API working from a script task? Any issues adding DLLs to the GAC?
 

 

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

 

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