|
|
|
|
Latest Blog Posts
-
|
Next week, on August 24th a new webinar from the PASS Application Development Virtual Group will be aired. This time the topic is the Cross-Platform support introduced with the forthcoming SQL Server 2017. Maximo Trinidad will delivery the following session:...
|
-
|
This seems to be a never ending story, having a locally installed Books Online for SQL Server, that is. Some of you recall that I have posted about this before. This post is about my experiences for the current state of Books Online. Things has changed...
|
-
|
Microsoft has released the following Cumulative Updates for SQL Server 2016 (RTM and SP1). Cumulative Update 7 for SQL Server 2016 RTM KB 4024304 Download Build number: 13.0.2210.0 SQL Release Services blog post Cumulative Update 4 for SQL Server 2016...
|
-
|
I was giving my Row Level Security session last weekend for the Richmond User Group ( @RichmondSQL http://rva.pass.org/) and a question came up (ok, so I technically asked the question). How does the feature work with indexed views? Generally speaking,...
|
-
|
I could complain about Entity Framework, but there is probably nothing that has not already been aired. So instead, I will complain about the lack of tuning options in SQL Server's Memory Allocated To Plan Caching. As of SQL Server versions 2005 SP2 and...
|
-
|
Had a client today asking about this situation. They were working away on a machine and suddenly they got the message “Failed to update the database because the database is read-only”. The user hadn’t changed anything that they were aware of. Based on...
|
-
|
Finding a new job can be a long and stressful proposition. This holds true even for skilled candidates. And even for skilled candidates in an atmosphere like we have in 2017—in which everyone who is employable is, for the most part, employed, and IT positions...
|
-
|
T-SQL Tuesday turns this month to the topic of job interviews . Kendra Little ( @kendra_little ) is our host, and I really hope her round-up post is in the style of an interview. I’m reminded of a T-SQL Tuesday about three years ago on a similar topic...
|
-
|
The newest version of SQL Server Management Studio is now available for download. Lots of new features and fixes. The details and download links can be found here . Happy managing, Andy Kelly...
|
-
|
Dealing with CSV or JSON data today is more and more common. I do it on daily basis, since the our application send data to our microservice gateway backend is in a (compressed) JSON format. Sometimes, especially when debugging or developing a new feature,...
|
-
|
SQL Updates Newsletter – July 2017 It has been a few months since my last post on these but here is the latest update about the monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month....
|
-
|
The sessions of the event 24 Hours of PASS " Summit Preview " edition (held the last July 2017 on 19 and 20) were recorded and now they are available for online streaming! If you have missed one session or the entire event, you can view or review your...
|
-
|
Hello SQL Folks! SQL Server 2017 RC2 has been released. More details can be found here . There are lot of great new features apart from what we love the most – SQL Server on Linux. However in this release some bugfixes have been made along with performance...
|
-
|
I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always have access to the latest version of the language. Well, in reality I see that new features appears...
|
-
|
How is your health? How is your job in information technology affecting your health? I want to know! Since I started blogging here almost a decade ago as a new Microsoft Most Valuable Professional, I’ve become a registered nurse and now I’m a full-time...
|
-
|
A while ago I quietly announced the new home for sp_whoisactive, whoisactive.com . Today I finished migrating all related content -- including the documentation consisting of a series of 28 articles posted on this blog a while back. So if you're looking...
|
-
|
Scenic City Summit is a one day conference in Chattanooga, the Scenic City Summit is a new experience for me, although in a familiar, Devlink-esqe setting of the Chattanooga Convention Center in Chattanooga, TN. I am looking forward to attending, and...
|
-
|
After years and years talking about Business Intelligence and Business Analytics, this year at PASS I’ll be speaking about Application Development and how to make the best use of the data platform that Microsoft created so far. I’ve started talking about...
|
-
|
Hello SQL Folks! SQL Server 2017 RC1 has been released. More details can be found here . There are lot of great new features apart from what we love the most – SQL Server on Linux Take your time and play with SQL Server now Cheers Damian...
|
-
|
After a long run on our current hosting provider, SQLblog will be moving to a new hosting provider. During this process, starting later this evening, SQLblog will be offline for a day or two while I migrate the site to the new hosting provider. Please...
|
-
|
I coauthored my 15th book Together with Christian Cote (lead author) and Matija Lah (coauthor) we publishes SQL Server 2017 Integration Services Cookbook . Of course, it is kind of early to say this is a definitive guide to SSIS 2017. More accurate name...
|
-
|
Hello SQL Fans!! It is time for you to join SQL Saturday in Katowice!!! More details here Cheers Damian...
|
-
|
Recently Microsoft released a preview version of the SQL Server Diagnostics extension to SSMS. You can read more about it here . I downloaded it from here and you can see the results below. If you install the extension while SSMS is up and running, you’ll...
|
-
|
This week I will experience a couple of events associated to the number 50. SQL Saturday Atlanta The second will be my 50th SQL Saturday Event! (49th speaking, 1 attended in casual mode… 50th speaking Saturday will be in August at SQL Saturday Louisville)....
|
-
|
The Director of Sales Excellence at Microsoft is once again giving away free E-Book downloads. Apparently millions of them in fact on all sorts of topics and products. Well not millions of different E-Books but millions of them were downloaded last year...
|
|
|
|
|
|