A Fine Slice Of SQL Server
Mihalis Tsoukalos extracts, explores, and visualizes data (with D3) from a Kafka topic:
Now that you have your data in JSON format, you will use D3.js in order to visualize it. As JavaScript code is embedded in HTML files, the final version of the D3.js code can be found in
visualize-spatial.html, which contains the following code:
D3 is extremely powerful, though that power comes with a fairly steep learning curve.
Comments closedJay Kreps announces a new naming for KSQL:
Today marks a new release of KSQL, one so significant that we’re giving it a new name: ksqlDB. Like KSQL, ksqlDB remains freely available and community licensed, and you can get the code directly on GitHub. I’ll first share about what we’ve added in this release, then talk about why I think it is so important and explain the new naming.
There are two new major features we’re adding: pull queries and connector management.
This looks really interesting.
Comments closedJohn Morehouse has an interesting use case for resumable indexes:
Documentation on ALTER INDEX provides which options we can set when resuming a rebuild or creation operation:
<resumable_index_option> ::=
{
MAXDOP = max_degree_of_parallelism
| MAX_DURATION =<time> [MINUTES]
| <low_priority_lock_wait>
}
<low_priority_lock_wait>::=
{
WAIT_AT_LOW_PRIORITY ( MAX_DURATION = <time> [ MINUTES ] ,
ABORT_AFTER_WAIT = { NONE | SELF | BLOCKERS } )
}This means that we can change the MAXDOP, MAX_DURATION, and WAIT_AT_LOW_PRIORITY.
I’m going to gather that this was not necessarily the original intent, but it’s pretty nice, as it means that you can resume with fewer cores and lower priority during the day, but more cores and higher priority after hours.
Comments closedPaul Randal walks through an installation error with SQL Server 2019:
I have a brand new Windows 10 laptop that I use solely for teaching, as the HDMI and SVGA connectors on my main laptop somehow have bad connections to the motherboard after a few years of traveling around the world. On the new laptop I have SQL Server 2017, and now that SQL Server 2019 RTM has shipped, and I’ve finished teaching for the year, I set out to install 2019 side-by-side with 2017 so I can move my teaching environment to 2019 and work on demos of the new features pertinent to what I teach.
Thinking this would be a smooth process, I kicked off the install wizard, went through it, hit go, and walked away. I came back half an hour later to see that all install steps had failed.
Read on for Paul’s solution.
Comments closedShaun J. Stuart points out impoliteness on the part of In-Memory OLTP:
It’s nice that they are labeled with [INFO], so you can be fairly sure they aren’t a major issue, but they still annoyingly fill up the log with information that is of no use to anyone outside of Microsoft. It would be nice if you could disable these messages but, to my knowledge, you cannot.
These are the types of error messages which should, by default, not write to the error log. My real bugbear is “Hey, we successfully backed up the transaction log!” You should not need a trace flag to turn that off; you should need one to turn it on for diagnostic purposes.
Comments closedNiels Berglund hits an annoying error after installing PolyBase on SQL Server 2019:
At MS Ignite in Orlando November 4 – 8, 2019, Microsoft announced the general availability of SQL Server 2019. At the same time, the SQL Server 2019 Developers Edition appeared as an MSDN download, and of course, I downloaded it and installed it on my dev box.
After the installation, I noticed that PolyBase did not start up correctly, and I saw dump files all over the place. After some investigation, I figured out what the issue was, and this blog post describes the fix.
This only affects Developer and Express editions, not Standard or Enterprise.
Comments closedKellyn Pot’vin-Gorman shares a slew of reasons why mssql-cli might fail to install:
The easiest scenario for many to deploy SQL Server 2019 on Linux to start working with it, is most likely an Ubuntu distribution, (flavor) of Linux. With that, you may want to play with the newest tool for command line execution of SQL, which isn’t sqlcmd, but mssql-cli. It’s got some awesome new features, which I won’t go into here, but focus on installation failures instead, which happens not because the installation is complicated but because of the demands still for Python 2.7 when 3+ versions are required for newer software.
mssql-cli requires Python 3, so I recommend checking the version before running the mssql-cli installation command, as this may save you a lot of work with dependencies. I’ll still go through the steps to if you want to force it to work with Python 2.7, but seriously, just using the right version of Python will make it so much easier.
Read on for just shy of a dozen different failure modes.
Comments closedErik Svensen shows how you can calculate the ISO week from a given year and week number:
Just wanted to share a M function that I just created to calculate the date from a Year and a ISO week number.
Click through for a few examples as well as the script.
Comments closed