 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | Presentations that are Easy on the Eyes Recently I was at a conference and was struggling to see some Visual Studio code on the large screen. As I age, I find myself trying to sit in the front of most talks if I need to see the screen. In this talk, the speaker was using the default dark theme in VS, and it was hard to read the C# code. It often doesn't matter if I can't read code, after all, I'm not coding during the talk, but I do like to try and follow along as the person is talking. I've had the same issues with presentation templates. Some companies seem determined to stand out with a colored template for their event, and as they try to differentiate themselves, some will invariably use darker colors for a background. I've run into more than a few of these where they look fantastic on a monitor but are barely readable on a projector. A few days later I ran across a post from Aaron Bertrand on using dark settings for SSMS. At first I thought that was a bad idea, and I debated this with a few people. I even asked a quick Twitter poll, with most people responding they preferred a light template, but only a few people responded. I decided to seek a little wider audience and see what others think. What colors are easier for you to see when someone presents? Do you prefer lighter backgrounds or darker ones? I know we all want higher contrast between the foreground and background, but as we add in code coloring and other elements, what do you prefer when you're watching something on a screen larger than a monitor? I do need to experiment a bit, and as Aaron suggested, blog about my settings. Mostly so that I have a copy of them that I can easily find on new VMs and machines. I don't think dark backgrounds are better on projectors, but I haven't really experimented. Let me know what you think, and perhaps I'll have a whole new look for you later in the year as I present in the fall. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.1MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | NEW SQL Clone - version 1 available now! Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free |
|  | | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
|
|
|
| | |  | Mickey Stuewe from SQLServerCentral.com Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly. More » |
 | Additional Articles from SimpleTalk Free download to all Simple Talk users. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML. More » |
| | Additional Articles from SimpleTalk Although the techniques of Database Lifecycle Management can reduce the timescales for the delivery of new functionality to business systems, what if the database 'layer' consists of several large interdependent databases and data flows with replication and audit? Does DLM scale to this level of complexity? Margaret Cruise O'Brien starts a series of articles that describes the practicalities of improving DLM within an existing framework and team supporting a multi-database multi-server system, by describing some of the database management problems and solutions in an enterprise-scale database. More » |
 | This is aimed at anyone responsible for SQL Server schema changes. The course teaches how to manage database changes throughout their lifecycle, helping to deliver more frequently and more reliably. London, September 25 - 27 2017. More » |
 | Jason Brimhall from SQLServerCentral Blogs Reporting Services Reporting Services is a pretty feature rich tool for delivering reports to various consumers. There is plenty of power... More » |
| | Grant Fritchey from SQLServerCentral Blogs This is my first ever guest blog post. Take it away Hazel Garcia. Though the gender gap narrows by the year,... More » |
|
|
| | | Today's Question (by Steve Jones): What is an assertion in computer science? (choose 2) |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: computer theory. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| Yesterday's Question (by Stanley Kapfunde): The following are SQL Server 2016 storage limitations. (choose 3)
Answer: - The files per database limit is 32,767
- The maximum number of memory-optimized data files database is 4,096
- The maximum files size of the log is 2TB
Explanation: The correct answers are: - Files per database - 32, 767 (true)
- memory-optimized files per database - 4,096 (true)
- filegroups per database = 32,767 (false)
- maximum file size for a data file - 16TB (false)
- maximum file size of the log - 2TB (true)
Ref: Maximum Capacity Specificiations for SQL Server - click here
» Discuss this question and answer on the forums |
|
|
| | | Sheraz Mirza from SQLServerCentral.com As per Microsoft documentation click here TEXT , NTEXT and IMAGE column will be removed from future , and are all alternative data tyes TEXT will be VARCHAR(MAX) NTEXT will be NVARCHAR(MAX) IMAGE will be VARBINARY(MAX) this script is useful to see all these column in whole database and will display Table name , Column Name and Data Type heading for better understanding , System Table sys.types is used to check system_type_id for every data type, so we can use same script to find any specific data type columns in whole database by just changing value for system_type_id IN list  in above query 34,35,and 99 are system_type_id's for TEXT, NTEXT and IMAGE data types NOTE: above query will display one extra table "dtproperties" which is because microsoft changed "XTYPE" to "U" in object types after SQL SERVER 7. just avoid that column More »
|
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
Primary Key Indexes - I have a table in a database (it's a data warehouse) which is populated once a day by a truncate... Intermittent Kerberos issues with SQL 2016 - Has any one else experienced Kerberos issues with SQL 2016? We have 4 servers, dev, test, uat and prod running SQL...
SFTP Options with SQL 2016 ? - Does SQL 2016 have any native support for SFTP ? Looks like previously 3rd party add-ins were the way only option.
Index fragmentation - I have a table with two indexes. It has showing 60% fragmented. So tried rebuild the indexes. Still indexes are showing... SQL server 2014 is very slow - Based on this report(performance monitor) can any one tell why the Sql server is running slow. many application have slow...
Advice on creating unique clustered index - I've been studying the possibility of indexing a particular view that takes 26 minutes to run, trying to optimize it. ...
Connection Failed:: The target principal name is incorrect. Cannot generate SSPI context - Dear MVPs I migrated a database from SQL Server 2008 running on windows 2008 R2 to a new SQL Server... How to create backup using Mdf and ldf files to another location - Hi, I took backup of mdf and ldf file in another location. But when i try to attach the files using the...
Stored Procedure history - Hi All Is there anyway to get the stats (logical reads, physical reads, elapsed time etc) of the last perhaps 20...
Split column value to rows. - Hi All, I was looking for code to split column value into separate rows.. Any help on this.. like for the example below... SP output is -1 - when we get a store procedure output as -1 ? Help with query - Hi all, I'm having a moment, and I can't seem to get the query right. I'm trying to get the actual...
Searching for text - High everyone, I've a simple table that holds UK postcodes and I want to do a search on the postcode. The...
Corrupted index - find out what caused it - Hi I got this error on a scheduled integrity check. SQL 2005 sp2 Data row does not have a matching index...
Script out permissions - Azure SQL database - Hi Folks, Any one has a script to script out user permissions from Azure SQL database? I was not able to...
IIF statement and the Else clause - I'm trying to add a filter to my report. The report has a column with 3 values (Red / Green / Yellow). ... How can I create a report from the supplied table? - I need to create a report using this data. The data represents a chest x-ray result on a patient. I created...
SSIS - OLEDB Task - TempDB space issues - I haven't really worked much on SSIS, i am running into some serious tempdb issues. I know quite a bit...
Update on differences in table types (temp/var/user) - I'd like a short piece that explains the differences between temp tables, table variables, regular tables, user defined table types. When...
GREATEST and LEAST function - Hi, I'm looking for a function in T-SQL for getting the biggest or the smallest value between two or more columns... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
