blog.sqlconcepts.co.nz
SQL ConceptsA blog about SQL Server, SSDT and related technologies
http://blog.sqlconcepts.co.nz/
A blog about SQL Server, SSDT and related technologies
http://blog.sqlconcepts.co.nz/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
4.5 seconds
16x16
PAGES IN
THIS WEBSITE
20
SSL
EXTERNAL LINKS
6
SITE IP
172.217.6.83
LOAD TIME
4.517 sec
SCORE
6.2
SQL Concepts | blog.sqlconcepts.co.nz Reviews
https://blog.sqlconcepts.co.nz
A blog about SQL Server, SSDT and related technologies
blog.sqlconcepts.co.nz
SQL Concepts: December 2011
http://blog.sqlconcepts.co.nz/2011_12_01_archive.html
SQL Concepts: Delete files by age using FORFILES
http://blog.sqlconcepts.co.nz/2011/11/delete-files-by-age-using-forfiles.html
SQL Concepts: SSDT SQL Agent Job Deployment Template
http://blog.sqlconcepts.co.nz/2012/09/ssdt-sql-agent-job-deployment-template.html
SQL Concepts: March 2013
http://blog.sqlconcepts.co.nz/2013_03_01_archive.html
SQL Concepts: September 2011
http://blog.sqlconcepts.co.nz/2011_09_01_archive.html
TOTAL PAGES IN THIS WEBSITE
20
SqlSandwiches - Page 2
http://www.sqlsandwiches.com/page/2
Find failed SQL jobs with powershell. January 30, 2012. February 7, 2012. This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again. Kent Chenery ( blog. Did a nice session on powershell for n00bs and it got me thinking that I need to start posting some of my powershell stuff up here. Log on to server A. Open up management studio. Open up SQL Agent’s job. Order by last outcome. Rerun the jobs that failed. Repeat for servers B, C, D….and on. Let's set up the email stuff.
Find all failed SQL jobs with powershell
http://www.sqlsandwiches.com/2012/01/30/find-failed-sql-jobs-powershell
Find failed SQL jobs with powershell. January 30, 2012. February 7, 2012. This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again. Kent Chenery ( blog. Did a nice session on powershell for n00bs and it got me thinking that I need to start posting some of my powershell stuff up here. Log on to server A. Open up management studio. Open up SQL Agent’s job. Order by last outcome. Rerun the jobs that failed. Repeat for servers B, C, D….and on. Let's set up the email stuff.
TOTAL LINKS TO THIS WEBSITE
6
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...
Chupando Rueda | Everything about anything
April 28, 2015. My goals for this race are simple:. Finish it without stop. Run it using my sandals. Follow my plan of going conservative until mile 10, and then increase my pace. Since this is my first outside race in Pitts somethings can go wrong. Consistent Winning and Pitts Half Marathon. April 28, 2015. It looks like we are resting too much but I can tell you that I feel very relaxed for my half this coming Sunday. I will explain more in other posts. April 19, 2015. April 18, 2015 at 10:18PM. It is ...
SOCIAL ENGAGEMENT