sqlburn.com

SQLBurn

It is all about the check boxes. Thursday, May 14, 2015. How to keep users from doing a select * on a table. We all know doing a select *. On a table is not good practice. But how do you keep the users, especially report writers, from doing just that? Well it is fairly easy but I would check with the application owner/developer before implementing this. And, as always, do this in dev and test first. That assumes you are lucky enough to have a dev and test environment. Create table dbo.computed. There is ...

http://www.sqlburn.com/

OVERVIEW OF sqlburn.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

14

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLBURN.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

January

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Sunday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.2 out of 5 with 9 reviews

5 star

2

4 star

2

3 star

3

2 star

0

1 star

2

Hey there! Start your review of sqlburn.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT SQLBURN.COM

Contact Privacy Inc. Customer 0134410459

Contact Privacy Inc. Customer 0134410459

96 M●●●● Ave

To●●to , ON, M6K 3M1

CA

1.41●●●●5457

sq●●●●●●●●●@contactprivacy.com

View this contact

Contact Privacy Inc. Customer 0134410459

Contact Privacy Inc. Customer 0134410459

96 M●●●● Ave

To●●to , ON, M6K 3M1

CA

1.41●●●●5457

sq●●●●●●●●●@contactprivacy.com

View this contact

Contact Privacy Inc. Customer 0134410459

Contact Privacy Inc. Customer 0134410459

96 M●●●● Ave

To●●to , ON, M6K 3M1

CA

1.41●●●●5457

sq●●●●●●●●●@contactprivacy.com

View this contact

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

DOMAIN REGISTRATION INFORMATION

REGISTERED: 2013 May 03
UPDATED: 2014 May 02
EXPIRATION: EXPIRED REGISTER THIS DOMAIN

BUY YOUR DOMAIN

DOMAIN AGE

11

YEARS
11

MONTHS
25

DAYS

NAME SERVERS

1: ns1.hover.com
2: ns2.hover.com

REGISTRAR

TUCOWS DOMAINS INC.

WHOIS : whois.tucows.com

REFERRED : http://domainhelp.opensrs.net

CONTENT

PAGES IN
THIS WEBSITE

14

SSL

EXTERNAL LINKS

0

SITE IP

74.125.69.121

LOAD TIME

0.281 sec

SCORE

6.2

PAGE TITLE

SQLBurn | sqlburn.com Reviews

<META> DESCRIPTION

It is all about the check boxes. Thursday, May 14, 2015. How to keep users from doing a select * on a table. We all know doing a select *. On a table is not good practice. But how do you keep the users, especially report writers, from doing just that? Well it is fairly easy but I would check with the application owner/developer before implementing this. And, as always, do this in dev and test first. That assumes you are lucky enough to have a dev and test environment. Create table dbo.computed. There is ...

<META> KEYWORDS

1 sqlburn

2 create the table

3 nahnahnah as 1/0

4 fill the table

5 while @i 10

6 begin

7 sometext

8 values

9 set @i=@i 1

10 select named columns

CONTENT

Page content here

KEYWORDS ON PAGE

sqlburn,create the table,nahnahnah as 1/0,fill the table,while @i 10,begin,sometext,values,set @i=@i 1,select named columns,select *,the results,have fun,posted by,sql burn,no comments,email this,blogthis,share to twitter,share to facebook,labels tsql

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

SQLBurn | sqlburn.com Reviews

https://sqlburn.com

It is all about the check boxes. Thursday, May 14, 2015. How to keep users from doing a select * on a table. We all know doing a select *. On a table is not good practice. But how do you keep the users, especially report writers, from doing just that? Well it is fairly easy but I would check with the application owner/developer before implementing this. And, as always, do this in dev and test first. That assumes you are lucky enough to have a dev and test environment. Create table dbo.computed. There is ...

INTERNAL PAGES

sqlburn.com

1

SQLBurn: Needed permissions to run DMVs

http://www.sqlburn.com/2014/12/needed-permissions-to-run-dmvs.html

It is all about the check boxes. Wednesday, December 3, 2014. Needed permissions to run DMVs. This post isn't about what Dynamic Management Views (DMVs) are. Or how they can be used. This post is how to let a non sql admin use DMVs. But why would a non admin want to use DMVs? There can be a number of reasons:. You have an app owner who wants to keep an eye on his database. Someone wants to build their own executive dashboard and wants to include DMVs results. You were told to do so. It was in Washington ...

2

SQLBurn: Send an email when SQL Server Agent starts

http://www.sqlburn.com/2014/01/send-email-when-sql-server-agent-starts.html

It is all about the check boxes. Saturday, January 18, 2014. Send an email when SQL Server Agent starts. Since SQL Server Agent is usually set to start when the database server starts, I will show you a poor mans way of alerting you when your database server has been rebooted. In a previous post. I showed you how easy it is to make SQL Server Agent run any job when it starts up. I am assuming you have db mail setup on your server. If you do not, here are the step by step instructions. Subject = @Subject,.

3

SQLBurn: How to update records in batch

http://www.sqlburn.com/2014/01/how-to-update-records-in-batch.html

It is all about the check boxes. Wednesday, January 8, 2014. How to update records in batch. Let's say an application admin's overnight process "accidentally" inactivated (soft deleted) 110,000 records in the database's client table. This clients table is the authority to the company's customers. Since management and the users are screaming, the application admin has tried to activate all 110,000 client records in one command. SET [inactive] = 0. Timing out so the update never completes. Unfolding, she s...

4

SQLBurn: How to keep users from doing a select * on a table

http://www.sqlburn.com/2015/05/how-to-keep-users-from-doing-select-on.html

It is all about the check boxes. Thursday, May 14, 2015. How to keep users from doing a select * on a table. We all know doing a select *. On a table is not good practice. But how do you keep the users, especially report writers, from doing just that? Well it is fairly easy but I would check with the application owner/developer before implementing this. And, as always, do this in dev and test first. That assumes you are lucky enough to have a dev and test environment. Create table dbo.computed. Why doesn...

5

SQLBurn: December 2014

http://www.sqlburn.com/2014_12_01_archive.html

It is all about the check boxes. Wednesday, December 3, 2014. Needed permissions to run DMVs. This post isn't about what Dynamic Management Views (DMVs) are. Or how they can be used. This post is how to let a non sql admin use DMVs. But why would a non admin want to use DMVs? There can be a number of reasons:. You have an app owner who wants to keep an eye on his database. Someone wants to build their own executive dashboard and wants to include DMVs results. You were told to do so. Links to this post.

UPGRADE TO PREMIUM TO VIEW 9 MORE

TOTAL PAGES IN THIS WEBSITE

14

SOCIAL ENGAGEMENT

SqlBurn

OTHER SITES

sqlbuff.com

sqlbuilder.codeplex.com

Oragon Architecture SqlBuilder - Home

Project Hosting for Open Source Software. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). Last edited Feb 9, 2013 at 1:44 AM. There is no recommended release for this project. Version 8.4.2015.21029.

sqlbump.blogspot.com

SQL Bump

MS SQL Server Blog. Tuesday, January 4, 2011. For presentation purposes on reports, i often need to show the data in CSV. The CSV string are normally very similar and for long string of CSV, it become very unsightly. So i wrote a small function to compress the CSV string. From “0001,0002,0004,0005’ to “0001,2,4,5”. Csv list nvarchar( max. Item = stringval, max len = max. Com len = max. Apply dbo.F TABLE NUMBER RANGE (1, l.max len) n. Item, 1, n.NUMBER) = max. Item, 1, n.NUMBER). Csv list, ','. Number tab...

sqlburger.blogspot.com

SQLBURGER

Quinta-feira, 14 de março de 2013. Atualização do cache do Intellisense–Microsoft SQL Server. Esta é uma dica rápida pra quem tem dificuldade em trabalhar com o Intellisense do SQL Server. Para este exemplo, estou usando a versão 2008R2, então creio que isso se aplique a todas as versões a partir da 2005. Muitos desabilitam o intellisense exatamente por não compreender o comportamento da ferramenta, porém ela é muito útil. Compartilhar com o Pinterest. Domingo, 6 de janeiro de 2013. 1ª opção: Buscando os...

sqlburn.com

SQLBurn

It is all about the check boxes. Thursday, May 14, 2015. How to keep users from doing a select * on a table. We all know doing a select *. On a table is not good practice. But how do you keep the users, especially report writers, from doing just that? Well it is fairly easy but I would check with the application owner/developer before implementing this. And, as always, do this in dev and test first. That assumes you are lucky enough to have a dev and test environment. Create table dbo.computed. There is ...

sqlbusinessdesign.co.uk

Powerful Business Systems

Please contact us using this form. You can alternatively call us on 0203 0053 793. Please enter your name. Please enter a valid e-mail. Invoice and Customer Management. Boost Productivity By 300% - Sell More, Faster. Let's Go ». Reduce Costs, Errors, Boost Effeciency and Automate Any Tasks. Let's Go ». Manage and Grow Your Customer Base More Effectively. Let's Go ». Quickly Generate Hot Leads and Manage Your Pipeline. Let's Go ». Automated Business 2 Business Dialler. Let's Go ». Let's Go ».

sqlbutler.com

SQL Butler

SQL statements will appear here. Designed in DC / 2015.

sqlby.me

Sql By Mike Edwards

Monday, February 13, 2012. CentOS How to force an NTP Update. Posted by Mike Edwards. Subscribe to: Posts (Atom). Need some tips and tricks for Microsoft SQL Server 2008, check out The SQL Server. CentOS How to force an NTP Update. Have questions, ideas for articles, or just want to vent about something I've posted? Send me an email. Subscribe To sqlby.me.

sqlbydesign.com

SQL by Design Inc.

sqlbyjoseph.com

SQL By Joseph

Random thoughts on SQL Server, including SSIS, SSRS, SSAS, and other cool things like BIML! Easy cross server SQL Agent job monitoring solution (Part 1). We’ve had a pressing need in the environment I work in for a view of what SQL Agent jobs are executing when on multiple servers. The guys over at SQL Sentry have a good product with lots of bells and whistles. This first blog post will cover the stored procedures needed, and the second blog post will cover the SSRS reports. DECLARE @sql NVARCHAR(max); D...