mssql   3518

« earlier    

microsoft/mssql-scripter: Repository for the new SQL cross-platform command line tools
Python scripts for generating scripts out of a SQL Server database, including data, if needed.
mssql  python  opensource  foss  utility  script  database  data  dba  tool 
15 days ago by taffit
Stop Shrinking Your Database Files. Seriously. Now. - Brent Ozar Unlimited®
Don’t shrink your database files just to free up drive space. Stop.
I’m not going to reinvent the wheel by telling you why....Instead, I’m going to point to half a dozen posts explaining why:
database  shrink  mssql  sqlserver 
5 weeks ago by vegarev
GitHub - firozansari/TSqlCodeGen: TSqlCodeGen is a simple template based SQL script code generator which generates code using table structure.
TSqlCodeGen is a simple template based SQL script code generator which generates code using table structure. - firozansari/TSqlCodeGen
sql  code  query  generator  template  opensource  floss  mssql 
7 weeks ago by gilberto5757
clr enabled Server Configuration Option - SQL Server | Microsoft Docs
EXEC sp_configure 'clr enabled'; EXEC sp_configure 'clr enabled' , '1'; RECONFIGURE;
sqlserver  mssql 
11 weeks ago by dentarg
What is COPY_ONLY? | SQL Studies
You'll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain. Just in case you haven't: You should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain. But you may be asking why? What exactly…
mssql  backup  copyonly 
march 2019 by gilberto5757
sql server - How can I fill a column with random numbers in SQL? I get the same value in every row - Stack Overflow
UPDATE CattleProds
SET SheepTherapy= ROUND( 1000 *RAND(convert(varbinary, newid())), 0)
WHERE SheepTherapy IS NULL
mssql 
march 2019 by lalwanilov

« earlier    

related tags

201810  activedirectory  architecture  arm  assembly  auditing  aws  azure  backup  blog  bugs  cli  client  cloud  code  commandline  compare  comparison  concatenation  concatentation  connection  container  convert  copyonly  csv  cursor  data  database  databases  datafile  db  db2  dba  debian  disasterrecovery  docker  elasticsearch  error  example  excel  exchange  extension  fakerjs  faq  firebird  floss  foss  frature  free  gdpr  generator  golang  grouped  gui  guidance  ha  howto  hypersonic  import  info  install  installation  instance  issue  kerberos  knex  laertejunior  library  licensing  linux  mac  mariadb  masking  microsoft  migration  mongodb  ms  multiengine  mysql  odbc  opensource  optimization  oracle  oracletomssql  osx  password  performance  php  postgres  postgresql  powershell  programming  pymssql  python  query  rails  rdbms  rds  recover  recovery  recvoery  reference  repair  resolution  resources  sa  sap  schema  script  security  server  shrink  simpledb  single-user  single  software  sql  sqlbits  sqldb  sqlite  sqlserver  stackoverflow  sysadmin  table  technical  template  temporaltable  temporary  testing  tips  tool  tree  tsql  tuning  twitter  user  utility  version  versioning  vm  webdev  whitelist  windows  wsfc 

Copy this bookmark:



description:


tags: