分页: 1/317 第一页10111213141516171819202122232425262728... 317下页最后页[ 显示模式: 摘要 | 列表 ]
One of the most visited posts on my blog is nearly two and half years old now Add User to SQL Ser ...

SQL Server Fixed Role Permissions

[ 2017-03-09 15:14:02 | by 店小二03 ]
Roles and Permissions Someof my recent articles have been focused on permissions and security. T ...
By:Dallas Snider || Related Tips:More Application Development Problem I need to write a ...
A few weeks ago, I ran into aquestion on one of the forums asking for a script that can help the tea ...
使用Powershell管理Linux 下的 SQL Server 我们上一篇文章介绍了在Centos 7.3下安装及配置 SQL Server,今 ...
Today’s blog is originated from a blog interaction. After hardening a server, my friend was not abl ...
sql 字符串 数值型不走索引SQL_ID 99tfs2tpapwqk, child number 0-------------------------------------s ...
It is an usual practice to create a function to split the delimited sting in Sql Server, like the o ...

Interesting Stuff - Week 9

[ 2017-03-09 05:13:01 | by 店小二05 ]
05 Mar 2017 in categories: roundup tags: data science SQL Server Microsoft R Se ...
Question:Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? Answe ...
什么是PL/SQL?PLSQL语法游标存储过程/存储函数异常触发器。结构化查询语言(Struc ...
Sql语句如下USE goSET ansi_nulls ONgoSET quoted_identifier ONgoALTER PROCEDURE . @tb ...
SQL99是什么(1)是操作所有关系型数据库的规则(2)是第四代语言(3)是一种结构化查询语言(4)只需发出合 ...
SQLServer截取字符串数组,获取字符串指定值,截取字符串:例如 qweqe,1231423,werwer;qweqe,1231423,werwe ...
SQL Server 将JDE日期格式转换成常见日期格式JDE日期格式:JDE所有的日期字段在DB存储时用的是Julia date格 ...
SQL语言,是结构化查询语言(Structured Query Language)的简称。SQL语言是一种数据库查询和程序设计语言,用 ...
Today we’re going to talk about SQL Server instance stacking. Blasphemy!! Right, in product ...
This is one of the common question which is asked via emails to me. “How to apply the patch in Alwa ...

Friday Reading 2017-03-03

[ 2017-03-08 14:33:02 | by 店小二05 ]
I’m Andrew Pruski and I am a SQL Server DBA with 5 years experience in database development and adm ...

SQL Server 2016 Developer’s Guide

[ 2017-03-08 14:34:02 | by 店小二05 ]
I can proudly announce that it is already possible to preorder the SQL Server 2016 Developer’s Gui ...
Step 1. Run sp_Blitz and look for urgent warnings.sp_Blitz is one of the free scripts in our First ...

Blog Challenge: I am watching you!

[ 2017-03-07 21:25:01 | by 店小二04 ]
I decided to accept Grant’s (TheScaryDBA) challenge found here- http://www.scarydba.com/2017/03/02 ...
In this blog post we will discover how to fix an Add Failover Cluster Node Fails With Error. If you ...
Alex Kuznetsov wrote: Resilient T-SQL code is code that is designed to last, and to be safely ...
If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you will ...
分页: 1/317 第一页10111213141516171819202122232425262728... 317下页最后页[ 显示模式: 摘要 | 列表 ]