|
|
|
|
Latest Blog Posts
-
|
I am presenting my entire SQL Server Internals training online, an hour at a time, though DB Best. Check my blog there regularly for follow-up information including the slides and scripts, a link to the recordings, and solutions to homework exercises....
|
-
|
Hi SQL Folks, I just written a blog post about the functions and hidden gems in the USQL Summer Refresh 2017 Take a look there . and tell me what you think!!!...
|
-
|
Deep breath. There is two weeks and two day before the PASS Summit. And like the past few years, I didn't submit any sessions, so those three days will be nonstop learning and chilling with all of the SQL family who makes it to Seattle. But two weeks...
|
-
|
I recently published a new blog post on SQLBI. You can read it at this link: https://www.sqlbi.com/blog/marco/2017/10/10/offline-model-editor-experience-for-power-bi/...
|
-
|
You can read this blog post at this link: https://jorgklein.com/2017/10/11/azure-analysis-services-scheduled-autoscaling/ This blog has moved to https://jorgklein.com There will be no further posts on sqlblog.com. Please update your feeds accordingly....
|
-
|
The latest version of SSMS ( SQL Server Management Studio 17.3 ) is now available to download. There are a bunch of new features in addition to the usual bug fixes but some of the more popular ones are a new wizard to import flat files, increased...
|
-
|
We all know that Profiler and its background functionality SQL Trace has been deprecated since 2012. Right? And we have all switched to using Extended Events (XE), a long time ago, right? No, the reality is that many of us still uses the old tracing infrastructure....
|
-
|
Hi! - Great that you've found this page, but it's no longer here! You can find the content over at: http://blogs.lobsterpot.com.au/2017/10/10/the-bigdata-legacy/...
|
-
|
The Service Pack 4 of SQL Server 2012 has been released! This service pack contains: More than 20 improvements around performance and scalability All fixes released up to and including the Cumulative Update 10 for SQL Server 2012 SP3 The most important...
|
-
|
Another month, another session for the PASS Application Development VG. This time I will be both the host and the guest :), talking about something is very close to my interests and, I think, also a key point for any developer to have success in future...
|
-
|
Call for speakers for our event is closed. Now we have the hardest work. Out of 150 submitted fantastic session proposals, we need to select only 30. You can see a nice graphical summary of the submitted sessions prepared in Power BI by Tomaž Kaštrun...
|
-
|
I recently published a new blog post on SQLBI. You can read it at this link: https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/...
|
-
|
The first event on my Fall tour is behind me now. I had a wonderful time at SQL Saturday Holland. A couple of great questions came up that should lead to blog posts soon! Slides and scripts can now be downloaded from my DB Best blog site: https://www.dbbest.com/blog/thank-sql-saturday-holland...
|
-
|
Sign up for the new edX course Developing Planet-Scale Applications in Azure Cosmos DB at https://www.edx.org/course/developing-planet-scale-applications-microsoft-dat237x ....
|
-
|
Microsoft just announced a new serving model for SQL Server starting with SQL 2017. The link below goes into much more detail so I won’t duplicate that here. However in a nutshell this means that there will be no more service packs, only CU’s (Cumulative...
|
-
|
I'm taking off tomorrow for Holland, UK, Denmark, Germany and Israel: https://www.dbbest.com/blog/im-leaving-jet-plane/#more-11622 You can read the post from DB Best, linked to above, or follow individual links to my public events from here: September...
|
-
|
For years, I had thought (and was probably taught in SQL.AlongTimeAgoInAPlaceFarFarAway) that the timestamp column (well before rowversion was a thing,) was not guaranteed to be an ever increasing value. But this is not the case. In BOL ( https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql...
|
-
|
You can read this blog post on jorgklein.com: https://jorgklein.com/2017/09/26/azure-data-factory-and-ssis-better-together-with-adf-v2-preview/...
|
-
|
Another SQL Saturday has been scheduled in Parma (Italy), it's the SQL Saturday #675 and this year it will be more international than the previous editions because there will be six sessions completely in English (= 1 "virtual" track in English). SQL...
|
-
|
(This article was originally published at https://www.dbbest.com/blog/ ) Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored procedures. For example, we had sp_addindex and sp_dropindex , as well as sp_addtype...
|
-
|
If you are in the intersection of these two groups: Doesn't currently have a copy of my current database design book, or wants to give one to a friend who architects poor databases Will be attending the Microsoft Ignite Conference Then I have a great...
|
-
|
You can read this blog post on jorgklein.com: https://jorgklein.com/2017/09/19/azure-sql-database-scheduled-autoscaling...
|
-
|
I recently published a new blog post on SQLBI. You can read it at this link: http://www.sqlbi.com/blog/marco/2017/09/18/missing-automatic-update-of-data-gateway-for-power-bi/...
|
-
|
There are a couple of new CU’s for SQL Server 2016 that you should be aware of as it looks like there are a number of nasty looking bugs fixed. There is CU5 for 2016 SP1 and CU8 for 2016 RTM . SQL Server...
|
-
|
In my first 5 blogs on Temporal , I failed to note something pretty important about their usage. The start and end times for the row (and it follows, the historical rows) are likely not in your local time zone. They are stored in UTC time zone. This is...
|
|
|
|
|
|