SQL Blog - Blogs about SQL Server, T-SQL, CLR, Service Broker, Integration Services, Reporting, Analysis Services, Business Intelligence, XML, SQL Scripts, best practices, database development, database administration, and programming
http://blog.sqlblog.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
PAGES IN
THIS WEBSITE
20
SSL
EXTERNAL LINKS
0
SITE IP
207.115.88.196
LOAD TIME
0 sec
SCORE
6.2
SQLblog.com - The SQL Server blog spot on the web | blog.sqlblog.com Reviews
https://blog.sqlblog.com
SQL Blog - Blogs about SQL Server, T-SQL, CLR, Service Broker, Integration Services, Reporting, Analysis Services, Business Intelligence, XML, SQL Scripts, best practices, database development, database administration, and programming
blog.sqlblog.com
SQLblog.com - The SQL Server blog spot on the web
http://blog.sqlblog.com/tags/Business+Intelligence/default.aspx
THE SQL Server Blog Spot on the Web. Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in. Raquo; Business Intelligence. Free Webinar: Loading Medical Data to the Cloud. Join Andy Leonard and Kent Bradshaw of Enterprise Data and Analytics 11 Aug 2016 at 1:00 PM EDT as we discuss and demonstrate strategies for loading medical data to the Microsoft Azure SQL DB with SQL Server Integration Services (SSIS). Register today! July 25, 2016. 24 Hours of PASS (May 2016): Recordings Available!
SQLblog.com - The SQL Server blog spot on the web
http://blog.sqlblog.com/tags/SQLSat/default.aspx
THE SQL Server Blog Spot on the Web. Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in. Speaking at SQL Saturday #470 in Washington DC on Dec 5. I am pleased to announce that I will be speaking at SQL Saturday 470 in Bethesda, MD at the Microsoft MTC on Dec 5! The event is already sold out with a waiting list! Http:/ www.sqlsaturday.com/470/eventhome.aspxMy topic is ' First Look at SQL Server 2016' . Microsoft has been busy working on the next version of SQL Server - . December 2, 2015.
SQLblog.com - The SQL Server blog spot on the web
http://blog.sqlblog.com/tags/SQL+Saturday/default.aspx
THE SQL Server Blog Spot on the Web. Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in. Raquo; SQL Saturday. From Zero to SSIS! Upcoming Performance Seminars: Charlotte and Vegas! I am happy to report two more scheduled public deliveries of my new-for-2016 seminar, Tuning Your Biggest Queries! August 16, 2016. Conferences, User Groups, and Seminars Q3 and Q4 2016. July 19, 2016. PASS SQL Saturday #567 Slovenia 2016. So we are back again The leading event dedicated to Microsoft SQL Serv...
SQLblog.com - The SQL Server blog spot on the web
http://blog.sqlblog.com/tags/Performance/default.aspx
THE SQL Server Blog Spot on the Web. Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in. How TOP wrecks performance (part 2). In my previous post, I showed how the vanilla version of TOP can really help performance by nudging the optimizer into picking an execution plan that is optimized for returning just a few rows instead of the entire result set. But I also showed that adding WITH TIES causes a cardinality misestimate, which may lead to suboptimal or downright . June 25, 2016. This ...
SQLblog.com - The SQL Server blog spot on the web
http://blog.sqlblog.com/tags/Cronacle/default.aspx
THE SQL Server Blog Spot on the Web. Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in. Calling Cronacle web service QueryJob1 from PowerShell. 2 blog posts in 2 days. Hell must have frozen over On my current project we are using Cronacle as our job scheduler and we have a need to programatically query Cronacle to ask it the status of a job. The following script accomplishes that using PowerShell: Code Snippet function Ignore-SSLCertificates { . January 22, 2016. May 15, 2015.
TOTAL PAGES IN THIS WEBSITE
20
Voyage with Sqkii
A page for us to pen down our thoughts on starting up Sqkii. Page 1 of 3. Older Posts →. Your student card and its untold powers. It’s the time of the year again. Orientation camps, matriculation programmes, module bidding. As fresh-eyed students enter this seemingly unfamiliar phase of life, it is ». 3 reasons why I've not achieved an incredible life. Some time ago, I crafted a bucket-list of things that I will want to accomplish within the next few years. Pen in hand, paper in sight; ». Page 1 of 3.
DBA Blog
SQL Server blocked access to statement OPENROWSET / OPENDATASOURCE. Rating: strong 4.5 /strong out of 2499 votes cast /p '); return false;" class="starinfo" i. 05:29:00 pm, by tom.green. When executing queries using OPENROWSET statement, the following error can appear:. Msg 15281, Level 16, State 1, Line 1. This error appears because Ad Hoc Distributed Queries. Configuration parameter is disabled. To enable Ad Hoc Distributed Queries. Follow the next steps:. Command by enabling the 'show advanced options'.
Blog SQL42
Segunda-feira, 1 de setembro de 2014. Atualizando estatísticas em paralelo - usp update statistics v1. Hoje vou falar de estatísticas de tabelas, mas não de como o SQL Server utiliza ela nos planos, sobre este assunto eu sugiro se inscreverem no Webcast do meu amigo Thiago Alencar neste link. Irei compatilhar hoje uma rotina que utilizo para atualizar as estatísticas das tabelas dos bancos que administro. Antes de iniciar, recomendo também olharem os scripts do Ola Hallengren neste link. 160; parte 02.
SQL Authority with Pinal Dave - SQL Server Performance Tuning Expert
Live Training: Practical Real World Performance Tuning. Weekly Questions and Answers. SQL in Sixty Seconds. SQL Tips and Tricks. Exclusive] Practical Real World Performance Tuning – Live Training Session for Limited Time. I am happy to announce that the new course Practical Real-World Performance Tuning, along with Brent Ozar (blog) is now live. We are accepting the registration for a limited time. This is very unique opportunity to learn Performance Tuning with real-world examples. SQL Tips and Tricks.
SQLblog.com - The SQL Server blog spot on the web
THE SQL Server Blog Spot on the Web. Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in. Add SQLblog.com to. BI with SQL Server. Heading to SQL Sat NYC! I will be speaking at SQL Sat 380 in NYC on the topic of Basic Performance Monitoring with Perfmon. I have delivered this session many times and is usually well attended. The session is geared for the person who has heard of Perfmon but not used it. This. 2 hours, 59 minutes ago by RickHeiges. Want to Learn More About SSIS and Biml?
SQL Concepts
Friday, 5 April 2013. SSDT syntax highlighting disappeared. How I fixed it. I recently struggled with a problem where I seemed to lose the syntax highlighting in Visual Studio 2012 for SSDT projects. Took me a while to stumble onto a solution after multiple reinstalls and almost giving up to rebuild the PC (I like syntax highlighting). The tldr solution is:. Open a Visual Studio Command Prompt (as administrator). The problem (no pretty colours). To list all I had tried;. Patched SQL Server 2012 with SP1.
SQLEDT | Blog Test Data Generator, SQL Schema Compare, SQL Data Compare, SQL Intellisense, Database Navigation, SQL Designer, Script Generator, Quick Find, Quick Filter, and a lot more!
February 14, 2011 08:36 by. Here, we would like to consolidate a list of frequently asked questions, known issues and their resolutions/workarounds:. First, when SQLEDT encounters an unhandled exception, it shows a popup message where you should be able to click on a "View Details" button, like below. If you click the View Details button, you should see more information about the issues, some of which we have tried to summarize below:. Issue 2: "The input stream is not a valid binary format.". Starting w...
Blog SQLexpert | Blog about SQL Server, Business Intelligence, Data Warehousing, ETL, OLAP,…
July 27, 2015. Wakacje, prawie końcówka lipca, a tutaj nagle w piątek wychodzi nowa wersja PowerBI. Bardzo często nazywanego PowerBI 2.0. Od tego momentu można korzystać z wersji darmowej, a także przez 60 dni z wersji zaawansowanej (PowerBI trial). Wraz z PowerBI 2.0, przedstawiony kilka miesięcy temu PowerBI Designer zmienia się w nowe narzędzie PowerBI Desktop, narzędzie [.]. Test Your SQL Database Backup Today! June 18, 2015. Research SQL Server 2016CTP2 7/13. June 17, 2015. June 16, 2015. Rozwój spr...
blog.sqlgeek.pl – From data architect's life
From data architect's life. READY TO DEAL WITH YOUR DATA? Get some tips on how to do that! Rok 2016 dobiega końca. Jaki był ten rok dla mnie? Pełen zmian, nowości i prób, niekiedy dość trudnych. Mógłbym pewnie napisać dość ciekawą książkę w oparciu o swoje przeżycia z roku mijającego i poprzedniego, ale krótko wspomnę tylko o najważniejszych wydarzeniach w moim światku w roku 2016. SQL Server 2016 SP1 – ulepszenia w Reporting Services. SQL Server 2016 – jak Service Pack 1 zmienił świat baz danych. Ostatn...
SQLGuy
Select Help,good advice From sys.dm db good performance. These postings are provided "AS IS" with no warranties. Friday, March 13, 2015. Simple Tools Series: Change the owner of all Databases to the SA login. Is a selection of simple every day scripts, that any DBA will need either on a daily basis or frequently. All databases is owned by the SA login! Links til dette indlæg. Friday, February 27, 2015. Simple Tools Series: Change the owner of all Jobs to the SA login. Links til dette indlæg. The error in...
